Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Access

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-26-2009, 09:14 AM
dalanengle dalanengle is offline Windows XP Access 2000 (version 9.0)
Novice
 
Join Date: Sep 2009
Posts: 3
dalanengle is on a distinguished road
Default How do I choose a record from a list and it populates a form?

I have a form that displays client information (named "Clients Information").
I have a drop down list on the firm that displays all the clients in my database. My question is how do I click on a client from the drop down list and have it fill in all the fields on the "Client Information" form. I want the list to be included on the Client Information form as well as all the fields.

Please help a newb out!!!

Thanks.
Reply With Quote
  #2  
Old 09-26-2009, 11:06 AM
RuralGuy's Avatar
RuralGuy RuralGuy is online now Windows 7 Access 2007 (version 12.0)
Administrator
 
Join Date: Mar 2007
Location: 8300' in the Colorado Rocky Mountains
Posts: 4,348
RuralGuy will become famous soon enoughRuralGuy will become famous soon enough
Default

Add another ComboBox to your form with the cbo wizard and select option 3.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
Reply With Quote
  #3  
Old 09-26-2009, 11:31 AM
dalanengle dalanengle is offline Windows XP Access 2000 (version 9.0)
Novice
 
Join Date: Sep 2009
Posts: 3
dalanengle is on a distinguished road
Default Thanks

That was ridiculously simple. Thanks a lot. I have been trying to figure this out for about three days! I have thousands of questions about this program. I'm new to this, just trying to make a program for my wife's business.

Thanks again! I'll probably have more posts I'm sure!
Reply With Quote
  #4  
Old 09-26-2009, 11:57 AM
RuralGuy's Avatar
RuralGuy RuralGuy is online now Windows 7 Access 2007 (version 12.0)
Administrator
 
Join Date: Mar 2007
Location: 8300' in the Colorado Rocky Mountains
Posts: 4,348
RuralGuy will become famous soon enoughRuralGuy will become famous soon enough
Default

Glad I could help. Go ahead and use the Solved thread tool.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
Reply With Quote
Reply

Bookmarks

Tags
fields, form, list, records, select

Thread Tools
Display Modes

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 Off
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
list attachments in form hawaiikim Forms 0 08-24-2009 09:08 AM
How to make a form default to new record rather then showing the first record... wabbalee Forms 3 06-27-2009 01:53 PM
Creating A Form to List Teams - Please Help spinny Forms 14 06-24-2009 05:36 PM
Open Form with a drop down list box Rinehart Forms 0 08-10-2008 06:53 PM
How do I choose multiple records for a report admaldo Reports 2 03-03-2006 03:02 AM


All times are GMT -8. The time now is 10:32 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.