Fields from diffrent tables in one form

[dealwi8me]

Hello all,

If i have a query as a Record Source of a form then i can't write to the fields i want, only if i have a table as a Record Source i can.

Any suggestions why might this is happening?

How can i add fields from diffrent tables in one form?

Thank you in advance!

 

[KenHigg]

You may want to consider using subforms.

???
Ken

 

[Mile-O]

Any suggestions why might this is happening?

Your query is, most likely, too complex due to multiple joins.

How can i add fields from diffrent tables in one form?

As Ken says, using a form and subform combination.

 

[dealwi8me]

the reason i want to have all the values in one form is because i have a form event (before_update) with code builder (Me.x=Me.y where x and y are in diffrent tables).

is there another way to assign values from one table to another?