Fill in form using query

[Smoki]

Hi,
I have form based on query. I want to choose value in one field on form, and
then the other fields on form to fill with appropriate values (one row from
table). I made query, I tried it, and it works.
But when I choose one value in that field, and then press command button to
refresh form, nothing happend - the other fields on form don't fill?! Why???
Maybe my problem is not in query - it works, probably with my form?! But,
how to fix it?

Thanks,
Smoki

 

[anlu]

Hi Smoki,

What does your query look like? And your code behind the command button.
Maybe you simply need to call the Requery method on the form?

Regards,
anlu

 

[Smoki]

Yes, the problem was really with my command button. I used CB Refresh form
data, and then I put new one CB Apply form filter, put some filter in a form,
and it works now. Thanks

Smoki