 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / May 2005Access 2003, How to select record from Combo box?
I'm an unable to select a record via a combo box, in help "Find a record by selecting a value from a list" it says "In the first wizard dialog box, click the option to find a record based on the value you selected in the list box or combo box", I don't seem to have this option. I thought that this would be a simple thing to do. the Access combo box wizard will not offer that third option unless your form is bound to a table, query, or recordset. double check your form's RecordSource property. hth > I'm an unable to select a record via a combo box, in help "Find a record by > selecting a value from a list" it says "In the first wizard dialog box, click > the option to find a record based on the value you selected in the list box > or combo box", I don't seem to have this option. I thought that this would be > a simple thing to do. > the Access combo box wizard will not offer that third option unless your > form is bound to a table, query, or recordset. double check your form's > RecordSource property. Tina, If by recordset you mean a direct SQL statement in the form's RecordSource, then no, the third option will not appear in that case. Only with a table name or saved query will the third option appear.  SignatureJeff Conrad Access Junkie Bend, Oregon oops, didn't check quite far enough, did i? thanks Jeff! :) > > the Access combo box wizard will not offer that third option unless your > > form is bound to a table, query, or recordset. double check your form's [quoted text clipped - 5 lines] > then no, the third option will not appear in that case. Only with a table name > or saved query will the third option appear. > oops, didn't check quite far enough, did i? thanks Jeff! :) No problem. :-) SignatureJeff Conrad Access Junkie Bend, Oregon > > the Access combo box wizard will not offer that third option unless your > > form is bound to a table, query, or recordset. double check your form's [quoted text clipped - 5 lines] > then no, the third option will not appear in that case. Only with a table name > or saved query will the third option appear. > Thanks Jeff, that clears it up even further. You're welcome Paul, glad to help. SignatureJeff Conrad Access Junkie Bend, Oregon > the Access combo box wizard will not offer that third option unless your > form is bound to a table, query, or recordset. double check your form's [quoted text clipped - 13 lines] > > Thanks Tina, I was missing the obvious and I didn't realise that the wizard would give you different options dependant upon your selections. you're welcome, Paul, and i hope you noticed Jeff's correction also, so you don't end up confused by my mistake! :) > > the Access combo box wizard will not offer that third option unless your > > form is bound to a table, query, or recordset. double check your form's [quoted text clipped - 13 lines] > > > > Thanks Tina, I was missing the obvious and I didn't realise that the wizard would give you different options dependant upon your selections. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.