Recent content by farey

Is it possible to make a query that stores similar field data from different two tables into single field. Like, customerName (from both tables to store in same field in query).

I have couple of subforms on my mainform. I use Count(textboxes) on each subform to count records entered on sunforms and then count all subforms total in mainform Count(txtbox). Problem is, subforms count when user loses focus from the current record so if user just enters data in subform and...

Yes I know the concept. But since I am new to access, I am looking for some codes.

I need to make my mainform fields required before any data can be entered into subforms. Mainform and Subforms are linked with LinkMaster Child ID. This should only be applied in this form. Would appreciate some assistance. Many thanks in advance