How can I do this...

[action]

I have a search form(A) that selects a customer code and passes it onto another form(B), I also need to select a second customer that will be placed on the Form(B) so that details can be reallocated.

How can I use the same Search form to do both tasks. To date I have not used variables and are unsure if this is how I would go about it or is there a betterway.

Advice welcome.

Thanks

 

[billyr]

If I understand, both customers will be selected from the same table? If so, why not use 2 CBOs. The second CBO would list every customer EXCEPT the one chosen in the first. Now you have both customers on the same form and haven't used much space.
Create a CBO listing all your customers. There is a wizzard for this or better yet, make a stored query, go to SQL Veiw copy the code and paste that into the source for the first CBO.
Now modify the query criteria to <> forms!formwhatever!combowhatever. Same routine, SQL view, copy code, paste it into source for CBO 2.
In the afterupdate event for CBO 1, requery CBO 2.