Access Record Display/Input in a Form

[jcwillette]

I have 2 forms in my db. The first one should look up a record by the first field and display the rest of the fields if the record is found. It should then display the subform record that it is linked to.

I am having trouble getting the record to display the fields after inputting the data into the first field. Can anyone help me on this?

Thanks.

I can supply more infor if needed.

 

[MStef]

Look at "DemoSubLA2000.mdb" (attachment, zip).
Open "frmMain" and use the field FIND RECORD (combo box).
Look at VBA.
I think it is what you need.

 

[jcwillette]

Thak kind of helped out, but still not what I was looking for. Here is my Input Form Fields;

VehicleID AutoNumber
License Text
State Text
Make Text
Model Text
Type Text
Color Text
Code 4 Yes/No Box


These are my Subform Fields;

VehicleID Numeric
DateID AutoNumber
License Text
Informed Yes/No Box
Date Date/Time
Time Date/Time
Reason Text
Checkpoint Text
Level Text
Section Text
Comments Text


I am trying to make my Input Form Field License lookup or search for the license in my database. If it finds the license, I want to display all the data for that license including all dates that I have inputed for that license. If it does not find the license, then I want to input all fields for that new license record.

The forms seem to be working fine by jumping from the Input Form to the Subform when entering data. When I get to the Comments section and do a final Enter - I get an error and it doesn't go back to the Input Form at the License Field.

Any help with this is very much appreciated. Thanks

 

[MStef]

Hello jcwillette!
Here it is, "DemoJcwilletteA2000.mdb" (attachment, zip).
When you want to input a new record, go to on an empti form (frmLicenseMain), via RECORD NAVIGATORS at the bottom of the form, or via
NEW RECORD icon.