form access

A

accessdesigner

users have access to two diffrent forms "FORMA" and "FORMB" from three
different forms. The first access works:

ACCESS1 (only allows user to select FORMA and disables a function towards
opening FORMB)

if forms![FORMA].visible then
me.checkB.enabled = false
end if

ACCESS2 (only allows user to select FORMB and disables a function towards
opening FORMA)
if forms![FORMB].visible then
me.checkA.enabled = false
end if

but the third form access gives an error if user selects to view either
forms (FORMA or FORMB):

ACCESS3 (allows user to select either FORMA or FORMB on same form)

but an error in its program code reads the following when the user selects
either option because its reading the previous programming code listed above
and cannot find the form:
"can't find form [FORMA]" if user selects to view FORMA
"can't find form [FORMB]" if user selects to view FORMB

how do i make the third form work by ignoring the two previous programming
codes?
 

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

Top