Forms - Calling Data from Another Table

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

Guest

Hi

I'm used to using lookups and forms etc but need to do something that I
think links queries, VBA (completely new to) and forms:

I have a form for creating new applicants

I want to build a form that allows the user to search a contacts table on
FirstName, MiddleName, Surname; receive a list of matches and then either

1. Select one of the matches which would then populate the applicants table

or

2. Reject the matches and create a new record as normal

Can you anyone point me in the right direction?

Thanks

James
 
James

If you have a "contacts table" that already has folks listed, why are you
copying the information over to an "applicants" table? You might have to do
something like this if you were using a spreadsheet-based approach, but
Access is a relational database ... you can simply store a foreign key value
that points to the record in the contacts table.

As for creating a new "person", take a look in Access HELP on "Not In
List"... there are examples and code there to help get your form working.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Hi Jeff

Sorry - I should have said - the contacts table is a linked table

I'm building a booking system. Once applicants have completed the training
they will be added to the proper contacts table using and SQL UPDATE query so
I want to avoid the user creating applicants that already exist in the linked
contacts table.

Cheers

James
 
James

I'm still not understanding the business need for having two copies of the
same person.

I do understand that one person might be in two different "states", but that
doesn't require two different tables in a relational database.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Back
Top