return record or blank

T

Tom

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....
 
M

Maha Arupputhan Pappan

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.
 
T

Tom

Right on the mark....thanks

Maha Arupputhan Pappan said:
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.
Click to expand...
 
Top