Problems creating a working macro

  • Thread starter Thread starter New2Access07
  • Start date Start date
N

New2Access07

I am having problems creating a working macro. I need it to complete the
following actions
In the frmHardware form, when I click the Computer Repair button I need it
to complete the following steps:
- Open a new record in the frmRepairHistory form.
- Take the PC serial number for the current record in the frmHardware form
and put it in the PC serial number field in the frmRepairHistory form.
My current script is

Form Name - Computer Repair
View - Form
Filter Name -
Where Condition - [tbl-Hardware]![PC Serial Number]=[tbl-Computer
Repair]![PC Serial Number]
Data Mode - Add
Windows Mode - Icon
 
Try this two-step macro:

Action: OpenForm
Form Name - Computer Repair
View - Form
Filter Name -
Where Condition -
Data Mode - Add
Windows Mode - Icon


Action: SetValue
Control Name: [PC Serial Number]
Expression: Forms!frmHardware![PC Serial Number]
 
Back
Top