Forms - Calling Data from Another Table

[James Mullan]

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

 

[Jeff Boyce]

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/

 

[James Mullan]

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

 

[Jeff Boyce]

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/