New record botton control

[thunderbolt1164]

Hi I am working on a database for my new business and need some help.

For each section I have 4 forms:

Tansactions Form (MainForm)
Transaction SubForm (Listing All Transactions)
DropOffs (for entering Supplier Information)
DropOffs Subform (for entering quantity and Items)

Now what I want to do is put a button for 'New Transaction' on the MainForm that will open a NEW Blank Form in DropOffs

Have got Transaction Subform set to show records information by double clicking the ID field......so have removed the Records counter control bar at bottom of mian Form.

 

[Alisa]

Are you asking for the code that should go behind your new record button?

 

[thunderbolt1164]

yeah...i think so

 

[Alisa]

docmd.gotorecord ,,acnew
You may need to set focus on the subform first

 

[thunderbolt1164]

Thanks for yo help..I got that working