return record or blank

[Guest]

A table has the ID Field set as primary key. I want to open the record,
through a form, by typing the ID Number in the ID Field. If the record does
not exist, a blank record should be opened. Thanks is anticipation....

 

[Guest]

1. Create a new form (frmID) and insert a text field (txtID).
2. Insert a subform (frmID Subform) with relevant fields in datasheet view.
3. Ensure that subform contains the ID field (ID) too.
4. Click the subform and select Data page tab from form properties dialog box.
5. In the Link Child Fields, insert ID.
6. In the Link Master Fields, insert txtID.
7. Save and try your input.

Hope this is helpful.

 

[Guest]

Right on the mark....thanks

1. Create a new form (frmID) and insert a text field (txtID).
2. Insert a subform (frmID Subform) with relevant fields in datasheet view.
3. Ensure that subform contains the ID field (ID) too.
4. Click the subform and select Data page tab from form properties dialog box.
5. In the Link Child Fields, insert ID.
6. In the Link Master Fields, insert txtID.
7. Save and try your input.

Hope this is helpful.