Text box contents dependent on combo box selection

[laurenm]

Is there a way to fill in the contents of a text box based on a selection of
a combo box in the same form? I am working on database which keeps track of
meeting details. In this database, there are requested meetings and confirmed
meetings, each has its own form. In the requested meetings form, a user can
mark a meeting status of "Confirmed". Then they will go into the Confirmed
meetings form, choose a confirmed meeting and fill out additional
information. Currently in the confirmed meetings table, I only have a
requested meeting ID to link the two tables, not the meeting name because I
don't want to have unecessary duplicate information. I would like the user to
go into the confirmed meetings form, pick the requested meeting ID of the
confirmed meeting and have another box, hopefully a text box, automatically
fill in with the meeting name associated with that meeting ID. Is there a way
to do this? I know there is a way to filter down choices for one combo box
based on the selection from another, but in this case I want just the info to
fill in based on the choice of another combo box. If someone could give me an
idea if and how I could do this, I would greatly appreciate it.

Thanks!
Lauren M

 

[Beth Melton]

Are you referring to Access?

If so then you can either use a query for the form and add the table
containing the meeting name field to the query and the form. Then when
a selection is made from your combo box the text box will
automatically fill in the meeting name.

Or you can use the DLookup function in the control source for the text
box that looks up the meeting name from your table:
http://msdn.microsoft.com/library/d...n-us/vbaac11/html/acfctDLookup_HV05187182.asp

If you have additional questions you may want to post them in one of
the Access newsgroups since that's where the Access experts tend to
hang out and you'll likely get a faster response.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[laurenm]

Thanks so much for your reply. I will try your suggestions.

I would love to post my Access question in the Access Newsgroup however the
only Access newsgroup I can find are Access Security, Access Internet, and
Access Install and Configure, which do not seem to apply to my question. If I
am missing my other choices, where do I need to look?

Thanks again for you help!
Lauren M.

 

[Bob Buckland ?:-\)]

Hi Lauren,

See if the links below help.

=======
Thanks so much for your reply. I will try your suggestions.

I would love to post my Access question in the Access Newsgroup however the
only Access newsgroup I can find are Access Security, Access Internet, and
Access Install and Configure, which do not seem to apply to my question. If I
am missing my other choices, where do I need to look?

Thanks again for you help!
Lauren M. >>
--
LLet us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.access
news://msnews.microsoft.com/microsoft.public.access.forms

or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.access
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.access.forms

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com