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

Problems creating a working macro 0
Creating Forms 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
"Compile error in table level validation expression " after format 0
cross referencing two worksheets 2
Form/ filter for report 2
PC Serial number recall 5
Improving Macro That Keeps First Letter 0

Top