Got a question on linking fields in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good afternoon.

I setup a table that has combo boxes setup to enable a drop down lists for
an user to select an office name and an office number. I am curious if there
is a way to make the table auto populate the office number field, based on
which office a user selects? Thanks.
 
As the controlsource of Combo2, use something like:

Select * From MyTable Where OfficeName = Forms!MyForm!CBOCombo1

In the AfterUpdate event of Combo1, and event procedure like:

Sub Combo1_AfterUpdate()
Me.Combo2.Requery
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
You must log in or register to reply here.

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

link form fields ?? 1
Combo box and parameter queries 2
Auto-Populate Form Field 1
Auto Update Text box 1
Auto Populate a field 0
Auto Populate a Field on a Form based on Certain Criteria 1
Setting the value held in a combobox 8
Problem with Combo box on form 1

Back
Top