form

H

Hong

I have two tables:
tbl1: ID# Part#, Problem Description.
tbl2: ID#, Supplier response Date1, Supplier response Date2.
So, tbl2 is for the follow up information.

I create a form:
Field1: ID#,
Field2: dlookup the information in tbl1. (no entry)
Field3: Enter Supplier response Date1
Field4: Enter Supplier response Date2

The user enter ID#, then enter Field3 and Field4.
But sometimes then enter Field3, then close the form. fews days later, come
back and try to enter the Field4.

But if they enter the same ID#, it doesn't show the Field3 is already enter.
how can I make it when they enter ID#, the information is already enter will
show.

Thank you so much for your help!!!!!!!!
 

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

Top