Nav Butns propty on SUBFORMS

  • Thread starter Thread starter mark R.
  • Start date Start date
M

mark R.

How is it possible that I created a SUBFORM in such a way
that ACCESS doesnot give me a Navigation buttons property
choice on the properties right click to set to "NO" ?

Do I have to set it in Visual Basic? I guess I could.
What would the event and code be?

Private Sub_subformname_ENTER() or CLICK() or what?
Me!SUBFORMNAME.NAVIGATIONBUTTONS=FALSE ? or what
end sub

NOTE:
Regarding one to many relationships and creating a subform
for the "many" table" as a mainform first and then
dragging it into the "one's " mainform as a subform, I
do not get a subform that displays the "next record"
automatically, as I do when creating a subform using the
wizard. So my question above is assuming I created the
subform using the wizard and not the "drag" technique,
because I want to display all "many" records for the
primary key and show the "next" new record all at the same
time.
 
if you have the main form open in design view, and have
selected the subform control, you won't find the property
there.
remember that a subform is still a form object in the
database window. close the main form. open the subform in
design view, from the database window. all your form
properties are available, including Navigation buttons.
hth
 
if I used the wizard to create the subform, is it
accessible from the database window as you say?
 
Wait, I think I found some critical information as to the
mystery.

my source object says table.tablexyz not subformname_xyz

So what's the difference?

Had I dragged a table into the subform window and not a
form?

Is that why I can't access the subform?
 
Back
Top