Datacontrol / Combo-box

[DanAusitn]

Hi again guys,

Just some help wanted for my project I have Googled this and had many attempts just don’t be able to seem to get my head around it, I have a form with a data control linked to access 2003 and a combo-box when I load the form the combo-box is populated with the data from the data control but I want to know if it is possible to select an item from the dropdown box and then the data control jumps to that item. Making it possible to view stock levels for that particular item on separate captions.

Thanks

[jrtox]

Hi again guys,

Just some help wanted for my project I have Googled this and had many attempts just don’t be able to seem to get my head around it, I have a form with a data control linked to access 2003 and a combo-box when I load the form the combo-box is populated with the data from the data control but I want to know if it is possible to select an item from the dropdown box and then the data control jumps to that item. Making it possible to view stock levels for that particular item on separate captions.

Thanks

Hello,

Yeah its possible.
just build Query in which you SELECT a ReCord from Database WHERE field is equal to your combo box.

 SELECR * FROM [I]TableName[/I] WHERE [I]FieldName[/I]='" & ComboBox1.Text & "'

Tell me it is want you want

Regards
Phils. Ervin

[DanAusitn]

Hello,

Yeah its possible.
just build Query in which you SELECT a ReCord from Database WHERE field is equal to your combo box.

 SELECR * FROM [I]TableName[/I] WHERE [I]FieldName[/I]='" & ComboBox1.Text & "'

Tell me it is want you want

Regards
Phils. Ervin

thanks alot for answering my question i dont fully undestand your answer but now i know what to research

thanks

[jamesd0142]

Basically it means that the sql statement in your programme is changed depending on what value is chosen in your combo box, by the user.

[jrtox]

thanks alot for answering my question i dont fully undestand your answer but now i know what to research

thanks

Hello,

Maybe you could study in this Link.

http://www.thescripts.com/forum/thread718154.html

Download my attachment.

Regards
Phils Ervin

[DanAusitn]

Hello,

Maybe you could study in this Link.

http://www.thescripts.com/forum/thread718154.html

Download my attachment.

Regards
Phils Ervin

hi , thanks alot I looked over this but i dont thin this method applies to me im becoming quite confused about this now , i am a begginer you can download my project Here im not asking you to do my project for me but if you did have the time I would appreciate it if you could look at it and help me solve this problem because it is holding my project back

Thanks again

[DanAusitn]

anyone got any advice?