A newbie type of question

[Eyedahoman]

Hello Everyone,

I am a relatively new user of Access. I have what I think is a simple
question.

I have a form named frmClientele. On this form I have a combobox
named cboChurchname. The combobox data is taken from a table names
Churches. I would like to have a button below the combobox that will
allow the user to click on the button to retrieve specific data from
the Churches table that relates to the combobox value. I would like
this data to be placed onto a new dialog box and/or form that would
show up after clicking the button. I have looked into doing Dlookups,
but I think this would be overkill. As an example, on the Clientele
form a user is entering a new client and selects First Baptist as the
Church (in the cboChurchname). Under that combobox is button labelled
ChurchInfo. The user could hit this button and pull up specific
predetermined data from the Church table. Eg. Address, Pastor Name,
etc.)

Any help would be immensely appreciated.

Thanks in advance.

Scott

 

[Larry Daugherty]

Concisely:

Most likely, the query for the combobox includes the Primary Key of
the target record. You will need that information when you open your
new form.

Create the new form. Create the query for the new form. It must
include the same ID referenced above.

In the OnClick code for your command button, place code to open your
new form and include a "Where" clause in which you pass the above
referenced ID.

I realize that the above leaves you with things to research and learn.
If you require more detailed help then post back with one issue per
post and describe what you have already done in your attempts to solve
that issue.

A couple of great newsgroups for newbies are:

microsoft.public.access.gettingstarted
microsoft.public.access.tablesdesign

HTH