subform in datasheet view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have tblmain and tbl history. I have created a subform within my main
form linking "ID" from two tables. When I open the form in the datasheet
view there will be a "+" by the ID number were if I can collapse the record.
However, the default when I open the form they are already collapsed (-).
How would I make it where it will be closed or "+" ( sorry, i don't know the
right term) when i open the form?
THANK YOU!
 
In the form's Open or Load event, try

Me.SubdatasheetExpanded = False
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unremovable horizontal scroll bar on subform 1
Link two subforms in datasheet view (one sub-form, one sub-subform 1
Subform (Datasheet) Error 2
Can't edit record in subform datasheet view. 1
subform 2
Highlight rows in a subform datasheet view 0
Datasheet view 2
Command Button with datasheet view 3

Back
Top