Current through Tab Control

  • Thread starter Thread starter jadeB
  • Start date Start date
J

jadeB

I am setting up a database that uses tab control. I want to choose a
record on the first page and then have the primary key for the
form/table be automatically used on the other tabs.

I would also like to be able to search for a particular record by just
typing in the primary key on a form. When I do this I would like the
whole record to show up on the form.

Any ideas?
 
Add another box for typing the search value. Don't try to use the same box
for storing/displaying the primary key, and also for searching: it gets too
confusing.

A simple option is to use a combo box to bring up the record you want. There
is a combo wizard for this in Access, or you can use the code in this link:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

If the other pages of the tab control contain subforms to show related
records, just set the LinkMasterFields/LinkChildFields properties of the
subform controls, and the subforms will show the related records correctly.
No code needed.
 
Back
Top