Search Form

[Beany]

Can someone please look at my database and sort out my search form for me............

it might b sumat simple....................

the search textbox works (it succesfully searches for the provider or site) from the listbox....

BUT the subform underneath the listbox doesnt work.................

i click on the record in the listbox but it shows the wrong info in the subform...... y?

can someone sort it out? thanks

 

[Peter Reid]

Can someone please look at my database and sort out my search form for me............

it might b sumat simple....................

the search textbox works (it succesfully searches for the provider or site) from the listbox....

BUT the subform underneath the listbox doesnt work.................

i click on the record in the listbox but it shows the wrong info in the subform...... y?

can someone sort it out? thanks

You should;

1. Include the field UserId (as the first field) in the query Query1
2. Change the code behind the listbox OnClick event to 'find' UserID rather than Provider

 

[Beany]

ive tried that but it didnt work...............

i must be doing sumat wrong....

is it possible that you can implement it in my database?

it would be a great help!

 

[Peter Reid]

ive tried that but it didnt work...............

i must be doing sumat wrong....

is it possible that you can implement it in my database?

it would be a great help!

Done!

PR

 

[Beany]

Peter thank you very much..........

ur a star........


so why is it Userid and not userID?

and what were the changes you made?

once again cheers buddy!