popup entry forms?

[cdoyle]

Hi,
I've been searching and haven't seen any examples, or this question come up before.

What I'm thinking about doing is,

I have a main form, on this form there are some yes/no type fields that will have additional info needed to be filled out depending on what they select.

so in trying to keep the number of controls on this form down, I thought about having it work like this.

When they select 'yes' a popup form will appear that and they can enter the additional info. When done they just close this popup form, and go to the next question.

The popup forms will be bound to a difffent table, so when the form opens it needs to know that the data being entered is part of the current record.

Is this a good way to go about this? I'm thinking this will help load times of the main form, and also save space. I think it will be better then mulitple subforms, and cleaner then a tab control.

Your thoughts?

 

[DeanRowe]

I don't usually post advice on here as I'm still a relative newbie so forgive me if this advice isn't correct as I'm just trying to help, but I hope it helps.

Create the form you want to popup, go into the "other" properties of the form and select "Popup" as Yes.

Probably the best method to use would be to write the code in the afterupdate event of the field where you select yes or no. Select the field, right click and select properties, under the event tab select afterupdate and click event procedure and "...". The following code should go in there:

if me.[yesnofield].value = "Yes" then
DoCmd.openform "Popup Form Name"
else
[enter similar code here if you want the user to have to fill out a different popup form or leave blank if you don't]
end if
end sub