return record or blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

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....
 
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.
 
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...
 
Back
Top