PC Review


Reply
Thread Tools Rate Thread

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

 
 
janine_docsonline
Guest
Posts: n/a
 
      29th Jan 2006
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 Removed)
www.docsonline.net.au


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup value based on a value in another field on the same form fipp Microsoft Access 1 2nd Sep 2009 06:01 AM
Populate field based on previous form Ben Pelech Microsoft Access Forms 9 29th Jul 2008 03:06 AM
Update/lookup value of one field based upon entry in previous field stevewrite@gmail.com Microsoft Access 2 9th Jun 2006 10:59 PM
Need to add to the lookup table from a form lookup field (Access) =?Utf-8?B?RG9nZ2Vy?= Microsoft Access Forms 0 13th Sep 2005 05:47 PM
Re: Populate form field based on input of previous field... SteveS Microsoft Access Form Coding 2 17th Sep 2004 05:21 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:39 PM.