More fields in form

[mickelingon]

Hi

I'm quite a biginner at this and I'm making a support form based on a query because I made a search function.
Now I would like to add some fields in the same form, but these are made in a nother table. How do I get these fields in the field list?

//Mikael

 

[Ron_dK]

Make a new query which has the fields from nother table. Bound the form to your new query and add the (new) fields to your form.

 

[mickelingon]

But if I do that the search doesn't work.
And if I do that and get the fields and switch back to the query for the search the new fields doesn't work
I guess I have to make an expression for the textbox and get the data from the table.
What do I put in the contorl source since I can't choose any of the fields from the table because the form is bound to the search query

Thanks

 

[Ron_dK]

Assuming you do your search thru a combo box, make a new combo and ensure that the new fields are in the selection list.