If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo box in a subform not querying correct data
HELP!!!
I have a combo box that resides in a subform. Before I open the MAIN form I set an imputbox to pick one of two values (user input). Then I open the main form and subform. The combo box in the subform uses a query reference with critera from the input box. Sometimes it works, sometimes it does not. I have tried all sorts of '.Requery' but can't seem to get the combo box to work properly everytime. If the data shows wrong and I pick smething, then it requeries....wierd!!! I sure could use a little help? Thanks -- David (Disneygoof) Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
#2
|
|||
|
|||
Combo box in a subform not querying correct data
Hi David,
what is the SQL for the RowSource of your combobox? Warm Regards, Crystal * (: have an awesome day * disneygoof via AccessMonster.com wrote: HELP!!! I have a combo box that resides in a subform. Before I open the MAIN form I set an imputbox to pick one of two values (user input). Then I open the main form and subform. The combo box in the subform uses a query reference with critera from the input box. Sometimes it works, sometimes it does not. I have tried all sorts of '.Requery' but can't seem to get the combo box to work properly everytime. If the data shows wrong and I pick smething, then it requeries....wierd!!! I sure could use a little help? Thanks |
Thread Tools | |
Display Modes | |
|
|