Form with subform help

[blackie1982]

Hi all,
Is there any way of showing data from two tables in one form without using a subform? When I do use a subform, it has the navigation bar at the bottom of it and the user can move forward in the subform without moving forward in the main form.

Please help!!

 

[Dave_cha]

If you go into the properties of the subform you can hide the navigation bar, record selectors etc under the format tab. You can get the subform looking like a list box in the main form.

 

[Dave_cha]

Speaking of list boxes, if all you want to do is view the data, you can add one or more list boxes to the main form and define the rowsource in each listbox. This will remove the need for subforms altogether.

 

[blackie1982]

Dave_cha,
thanks a million

 

[Rich]

you haven't linked the Child/Master fields for your form/subform