lookup column

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

Guest

I cannot make the focus of the form stay the same... I have many pieces of
equipment to attach to one technician... Every time I enter a piece of
information the lookup column goes blank... how can I make it stay the same
until I change it
 
Bradie

We're not there. We can't see your form, nor your table structure, nor ...

We may not have the same definition of "lookup column" that you have,
either.

If you have a one-to-many relationship (one technician can have multiple
pieces of equipment "attached"), a common way to handle this is to use a
main form for the technician, and a subform for the technician's equipment
attachments.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form - Lock Fields from Editing 0
Restrict entering Null or Empty in Textbox - Access 2007 0
Update Query for Lookup Combo Box 7
Subform based on query 5
Counting occurences with multiple entries 5
Form Lookup From Query - Display different from data in table 1
DLookup using multiple Fields 4
DATA FROM RECORDS ON SUBFORM 19

Back
Top