Subform

[Cwittmaack]

Is it possable to create a sub form using a single table. I can create one using 2 tables but am not sure on how to or if it can be done using 1 table. All i can find in forum is about multiple tables. Thank you for your help.

 

[pr2-eugin]

Because that is how the Forms and Subforms are meant to be used ! What is your design goal here?

 

[Cwittmaack]

user will enter a 2 digit rec # and a 4 digit txid # using a query
would like the records to show in a datasheet in sub form. Main form will display what they entered. No data will be entered or changed only view records. the table is stored on sql server I can make a form ato display the datasheet but just wanted it to look a little better. "Not just a datasheet displaying"

Thanks for the quick responce.