Passing Parameters & Requerying Data

  • Thread starter Thread starter Andy McNeil
  • Start date Start date
A

Andy McNeil

I'm designing a incident reporting database as an
internship project. The form allows users to select a
material number from a combo list or type one in
themselves, at which point they will be prompted to
another form where they can add info to a Materials table
(using the OnNotInList event).

Q1. Is there a way to pass the new (already typed-in)
material number in the Incident form to the
AddNewMaterials form?

Q2. Once the new material number is entered in the
Materials table, I need it to show up in the correct field
of the Incident form. However, when I try to use the
Requery method for the control (tied to the form's
OnActivate event), I get a message saying the field needs
to be saved first. How do I work around this problem?

Thanks.
 
-----Original Message-----
I'm designing a incident reporting database as an
internship project. The form allows users to select a
material number from a combo list or type one in
themselves, at which point they will be prompted to
another form where they can add info to a Materials table
(using the OnNotInList event).

Q1. Is there a way to pass the new (already typed-in)
material number in the Incident form to the
AddNewMaterials form?

Q2. Once the new material number is entered in the
Materials table, I need it to show up in the correct field
of the Incident form. However, when I try to use the
Requery method for the control (tied to the form's
OnActivate event), I get a message saying the field needs
to be saved first. How do I work around this problem?

Thanks.
.
Click to expand...
hi Andy,
A1. use online help to lookup OpenArgs.

A2. not sure... you mention 'Notinlist' event. Are you
setting Response=acdataerradded? - this will requery the
combobox. Otherwise, save the record before the requery.

Luck
Jonathan
 
Thanks for your help. Once I got help on OpenArgs I was
able to solve both problems.
 
Back
Top