By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,813 Members | 2,269 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,813 IT Pros & Developers. It's quick & easy.

Specifying parent child form by name

P: n/a
I have form with subform that has a button(one in parent, one in the
child) that calls the microsoft access find/replace object.

In order to make it a find only object I need to set the allowedits
property to false.

I was using the Me.AllowEdits however if my focus is set in the parent
form and I click the search in the child it doesnt work.

To make things easier I want to set the allowedits=false by calling the
parent and subform by name

If I have a parents form called pform and a child form called cform how
can I set the allowedits to false for both, calling them by name so it
doesnt matter where my focus is..

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
You could refer to:
Forms!pform.AllowEdits
Forms!pform!cform.Form.AllowEdits

Not sure why turning off AllowEdits would help a find though. There is a
Find button on the toolbar (binocular icon) that works in whichever form has
focus.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<td*******@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I have form with subform that has a button(one in parent, one in the
child) that calls the microsoft access find/replace object.

In order to make it a find only object I need to set the allowedits
property to false.

I was using the Me.AllowEdits however if my focus is set in the parent
form and I click the search in the child it doesnt work.

To make things easier I want to set the allowedits=false by calling the
parent and subform by name

If I have a parents form called pform and a child form called cform how
can I set the allowedits to false for both, calling them by name so it
doesnt matter where my focus is.

Nov 13 '05 #2

P: n/a
Thanks.. when you call the find replace command if you have allow edits
turned off then you will only see the fine menu rather then the find
and relplace menu..

Nov 13 '05 #3

P: n/a
Ah, that makes good sense.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<td*******@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Thanks.. when you call the find replace command if you have allow edits
turned off then you will only see the fine menu rather then the find
and relplace menu..

Nov 13 '05 #4

P: n/a
This worked like a champ. I was missing the seocnd .form when calling
the subforms.

Allen Browne wrote:
You could refer to:
Forms!pform.AllowEdits
Forms!pform!cform.Form.AllowEdits

Not sure why turning off AllowEdits would help a find though. There is a
Find button on the toolbar (binocular icon) that works in whichever form has
focus.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<td*******@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I have form with subform that has a button(one in parent, one in the
child) that calls the microsoft access find/replace object.

In order to make it a find only object I need to set the allowedits
property to false.

I was using the Me.AllowEdits however if my focus is set in the parent
form and I click the search in the child it doesnt work.

To make things easier I want to set the allowedits=false by calling the
parent and subform by name

If I have a parents form called pform and a child form called cform how
can I set the allowedits to false for both, calling them by name so it
doesnt matter where my focus is.


Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.