Problems creating a working macro

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
 
K

Ken Snell [MVP]

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form/ filter for report 2
Seek in Recordset not working. 2
How can I build a subform within a subform. 2
How do I lock the date and time in a memo field? 3
Realtionships and auto creating records. 3
cross referencing two worksheets 2
PC Serial number recall 5
Setting the value held in a combobox 8

Top