Subform question - just want to show one table

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

I just want a form to view one database
but on one part of the form, I want the tabular view (datasheet) of the
database
then on the bottom maybe in a subform, a regular form that shows the fields
for just one record that is selected in the datasheet above.

So when you scroll through the database in the datasheet view, the subform
on the bottom will show entire record.
This lets the user browse through the table quickly, yet see the entire
record on bottom.

Thanks
 
You can sync 2 subforms on a single mainform. Make the key field a textbox
on the mainform and link both subform keys to it. There may be an example in
the Orders form on the Northwinf sample database.

Be aware that if you intend to do any editing, you may have locked the
record in one form (simply by tabbing through it) making it difficult to
edit in the other.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Thanks
I did this and it links, but how do I show one of the subform as a datasheet
listing all of the records.
Right now it just shows one. THis way the user can browse the table, then
click on a record, and see the entire record on the other subform on the
main form. I am doing the linking in the link child and link master fields
to the main form text box that is key field. Am I doing this right?

Thank you for your help.
 
That can only happen if the main form is bound to the same data set (table
or query) that subform 1 is. Try unbinding it by deleting the recordsource
in the main form, and setting subform 1 to be viewed as a datasheet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Danny said:
Thanks
I did this and it links, but how do I show one of the subform as a datasheet
listing all of the records.
Right now it just shows one. THis way the user can browse the table, then
click on a record, and see the entire record on the other subform on the
main form. I am doing the linking in the link child and link master fields
to the main form text box that is key field. Am I doing this right?

Thank you for your help.


example
Click to expand...

I finally figured it out
Thanks sooo much
 
Back
Top