Access 2003 Lookup based on Lookup previous field - populate other records on Form

J

janine_docsonline

Just know what I want to do - not the QUERY I need to do it or if I can
with my setup:

Table ADDRESSES with basic fields
AddressID Text
Address MEMO
Dear Text
Email Text
Fax Text

Form TEST
Wantt to populate MEMO Address field in Form TEST based on AddressID lookup
field answer in form?

barrister1ID (lookup) choose JONESABC

Want
Address MEMO
Dear Text
Email Text
Fax Text

to populate with a query based on answer in FORM to AddressID. How do I
achieve this if at all?

Desperate here need this to be up and running on Tuesday. If the above makes
sense to the talented Access Database users ANY HELP would be greatly
appreciated. Including a yes you can no you can't.

(e-mail address removed)
www.docsonline.net.au
 

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

MEMO Field cut off on Form 3
Access XP Form with lookup 1
Auto-populate data in a form based on data entered in a form 1
Populating Table based on selection of one field 0
auto populate text box based on combo box value 1
Populate Field Based on Value of Previous Record 15
Populate Value from Unbounded Computed Textfield Field into Master Table 0
Checkbox field on form 2

Top