Navigating in the form

[ssxmetro]

I have a form bound to a table with a combobox. When I select and item in the
combobox, the other fields do not move to the selected record. What do I
need to do here?

 

[ssxmetro]

This still is not changing the record # at the bottom of the form. I have 447
records. No matter what value i choose in the combobox it stays on record 1.
The name of the ComboBox is DL_Name (it is populated by a query i created
called qry_comp_dl) There is also a subform that is populated by a different
table. So what would the code look like exactly using the names I gave you?

Assuming you set the combo to an ID, name, Item, or something like that,
right click on the combo and go to properties. Go to the events property and
select the afterupdate event. Click the button out to the right and start the
code builder. Type:
Me.filter = "[your id] = """ & Me.combo# & """"
Me.filteron = true
Your combo# will be listed, like combo10 or combo22

I have a form bound to a table with a combobox. When I select and item in the
combobox, the other fields do not move to the selected record. What do I
need to do here?

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ComboChoosesRecord.mdb" which illustrates how to do this.
You can find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=379

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[ssxmetro]

I downloaded this but it doesnt seem to work in yours either! I am using
access 2007. When i change the value of the combobox, it doesnt navigate to
the record!

 

[Roger Carlson]

Is your database in a trusted location? I sounds like the security settings
are not allowing VBA to run.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[ssxmetro]

yes, its on my company network

Is your database in a trusted location? I sounds like the security settings
are not allowing VBA to run.

I downloaded this but it doesnt seem to work in yours either! I am using
access 2007. When i change the value of the combobox, it doesnt navigate

[quoted text clipped - 11 lines]

 

[ssxmetro]

Any ideas on using a GoTo record macro? I tried to run one but it is giving
me fits and still won't navigate to the appropriate record.

Assuming you set the combo to an ID, name, Item, or something like that,
right click on the combo and go to properties. Go to the events property and
select the afterupdate event. Click the button out to the right and start the
code builder. Type:
Me.filter = "[your id] = """ & Me.combo# & """"
Me.filteron = true
Your combo# will be listed, like combo10 or combo22

I have a form bound to a table with a combobox. When I select and item in the
combobox, the other fields do not move to the selected record. What do I
need to do here?