View Full Version : Connection between listbox and input field elements


sancaguy
09-19-2007, 01:39 AM
Dear Supporters!

I'm a beginner VB user so I've a simple question about VB in Access.

I have a listbox and some independent input fields.
How can I realize if a user click on the list the actual record will appear in the fields.
I used the following code on the OnClick event:

FieldName.Value = ListBoxName.Value

But it sent me a "Run-time error 424 - object required" message.
What should I do?
Sorry for this easy question and previously thanks for help!

SGuy...

Uncle Gizmo
09-19-2007, 02:42 AM
Does each list box entry represent just one item of data, or does it represent several data items.

sancaguy
09-19-2007, 04:13 AM
Every field represent only one item of data from the query-based listbox.

S...

Uncle Gizmo
09-19-2007, 04:53 AM
Opps ...
I'm not making much sense! Will the selection from the list box be going into one field of your table, the table linked to the form the list box is on.

sancaguy
09-21-2007, 01:57 AM
Ok... It was really making not sense!
I could solve it with a form function but it wasn't necessary to make a macro for it.

Thanks for your patience,
Sguy...