select value of first row in a combo for a query

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

Guest

Hello I'm trying to use the first value in a combo box where the user has not
slected any value in that combo box.
The reason is that I need an Id from it. This combo box has dates in the
drop down list and I want the id from the most recent date.
Thanks
 
Accessidiot ha scritto:
Hello I'm trying to use the first value in a combo box where the user hasnot
slected any value in that combo box.
The reason is that I need an Id from it. This combo box has dates in the
drop down list and I want the id from the most recent date.
Thanks
Click to expand...

To select 1° Item
Me!cboName=Me!cboname.ItemData(0)

This action will not run the Event After Update, so you need to invoke
it by yourself

Call cboName_AfterUpdate()

If you need to set the cbo to NullValue:

Me!cboName=Null

@Alex
 
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

Setting a combo box value 8
Changing the Selection Fields in a Combo Box 4
return value based on combo box selection 3
Mult-Value Select returning ID# not text. 4
how to show data only from selected combo boxes ? 0
Combo Box errors - duplicating value in Primary Key -- can't save 1
Autofilling a form based on combo box selection 8
A-Z Sorting Combo 2

Back
Top