Creating new Records based on value in another form

  • Thread starter Thread starter Jesse via AccessMonster.com
  • Start date Start date
J

Jesse via AccessMonster.com

I have two forms. One has a list of tasks in datasheet view and another
creates audits for these tasks.

Lets call them frmPropertytasks and frmPropertyaudit respectively.

What I need to do is when a user double clicks on a location listed in
frmPropertyTasks I want it to open a new audit records in frmPropertyaudit.
I know how to open a from in add mode using the doubleclick event but I am
not sure how to pass that location to a field on the form.

Also keep in mind that you can also open frmPropertyaudit from a switchboard
so I would rather not have the datasheet field be the default.


Please help.
 
Jesse,

I think there would be two approaches to this, depending on the details
of your data and what you are really trying to achieve.

One is to use an Append Query to add a new record to the table that the
frmPropertyaudit form is based on, and then open the form at that newly
created record. Another is to open the frmPropertyaudit form at a new
record, and then use code such as...
Me.YourField = "YourValue"
.... to automatically insert the required values into the relevant fields.

If you need more explicit help with this, please post back with more
detailed information.
 
Back
Top