Query results to form

[clarkej]

hi im sorry if this has been answered somewhere already but i looked though a few pages and couldn't find anything that helped.



i have designed a database which shows results of a query in a List box in a form, the idea is that when the user selects a name the full info opens up in a new form allowing for data entry.

the problem is when i chick on the three test entries (37, 38 % 39) i have the select form, it always open up with the first one each time (37).

i have the command

Private Sub Lista20_Click()

DoCmd.OpenForm "Sales Form", , , "[leadID]=" & Me![leadID]

End Sub

if anyone can help me i would appricate it, ben bugging me for a few days now

Jay

[pbaldy]

If the listbox is multiselect, you can't refer to the listbox like that. If it's single select, that should work providing the value is numeric. What is the multiselect property of the listbox?

[weekend00]

besides, the form "Sales Form" must have filteron=true

[clarkej]

hey thanks for getting back to me unfortunally neither of those worked

i have up loaded screen prints of the properties of both the list box and the form.

this is my first time i've used access to do a database, (not to mention im having to use access 97) hope the screen prints help im guessing microsoft changed a few well things with later versions

J

[pbaldy]

Does this work?

DoCmd.OpenForm "Sales Form", , , "[leadID]=" & Me.Lista20

[clarkej]

hey thanks for your help guys,

but i decided to cut my losses and re built the whole thing over the weekend, and it works now, no idea what is different but their must be something thanks again

[pbaldy]

Glad you got it sorted out; sorry it had to be "the hard way". Welcome to the site by the way.

[clarkej]

Glad you got it sorted out; sorry it had to be "the hard way". Welcome to the site by the way.

thanks for the welcome, im sure i'll be picking brains over the next few weeks and as for the hard way, i dont really care so long as it works lol