How to Make Make a Default Record Selection from a Combobox

[number2]

How can I have a combox lookup a default record (first record)automatically?

 

[LonnieJohnson]

As the row source to the combo box use...

SELECT First(MyTable.MyField) FROM MyTable;

Hope this is what you are looking for.

ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[number2]

Thanks for the help. Let me see if I can explain..the conbox box is used to update the feilds which follow it. (In this case, address and contact info; On selecting the name from the combobox the rest of the contact information is placed into their feilds) I currently use the following in the row source:
SELECT DISTINCTROW [evaldr query].[evaldr], [evaldr query].[evaldradd1], [evaldr query].[evaldradd2], [evaldr query].[evaldrphone], [evaldr query].[evaldrfax], [evaldr query].[evaldrlic], [evaldr query].[qmenumber], [evaldr query].[specialty], [evaldr query].[evaldrtaxID] FROM [evaldr query];

Can SELECT First be used with the DISTINCT ROW parameter?

 

[LonnieJohnson]

You would not use the DISTINCTROW and put last First in front of each field.

Hope this works for ya.

prodevmg@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV