Setting subform properties

M

mscertified

I have 2 forms; one for editing data and another for viewing the same data.
Both forms contain the same subform. I'd like to dynamically set the
ALLOWEDITS etc. properties on the subform based on each main form. How would
I do this?

Thanks.
 
D

Damon Heron

In the main forms' load events, put
Me!yoursubformname.Form.AllowEdits = False 'or true if it is the form for
editing


HTH
Damon
 
M

Marshall Barton

mscertified said:
I have 2 forms; one for editing data and another for viewing the same data.
Both forms contain the same subform. I'd like to dynamically set the
ALLOWEDITS etc. properties on the subform based on each main form. How would
I do this?
Click to expand...


You will probably be better off placing the code in the
subforms:

Me.AllowEdits = (Parent.Name = "edit form's name")
 

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

Populate main form from subform record 0
Setting column width in a table with a macro is not working 0
Subform Allow Edits Issues ? 5
RecordsetClone on a subform 3
set focus to control on subform 0
main form/subform 1
Locked Subform still lets me delete a record 2
DLookup in Continuous form 0

Top