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

Preventing Additions or Edits ... need help

P: n/a
Hi. I have a form that is open with AllowAdditions and AllowEdits both
set to False. I don't want to allow edits on this screen at this point
in the "flow". Opening up a second form seems to be affecting those two
attributes because when the 2nd form is closed the 1st form is then
'updatable' (is that a word?). What happened and how can I fix it?

Here are the details:

The form (frmDogs) has a command button (btnNewOwner) which when clicked
causes a second form (frmPeople) to open. Because the frmDogs is
"bigger" than frmPeople, I set the Visible attribute to False within the
btnNewOwner_Click( ) subroutine (before opening up frmPeople). That way
only the frmPeople is visible. Less distracting.

I open up frmPeople in Dialog mode to pause the processing in
btnNewOwner_Click( ) in frmDogs. I do this so that I may regain control
and "reposition" the recordset after frmPeople closes.

When the Close button of frmPeople is clicked, before closing itself
(and revealing frmDogs), it sets the Visible attribute of frmDogs back
to True. When I return to frmDogs, I am able to modify all the fields
on the form. NOT GOOD.

The question is HOW DID THAT HAPPEN? I don't want it to happen. I have
traced the routines and set a "Watch" break on the Me!allowadditions
variable (from within frmDogs) and the value never changes from False.
Help! I'm stumped.

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***
Feb 1 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.