Re: Newbie Questions
- From: "Ed Warren" <eowarren@xxxxxxxxxxxxxxx>
- Date: Fri, 5 Aug 2005 05:40:31 -0500
It might help to provide a more specific example. I'm not really too sure
exactly what you want to do, but I'm equally sure, it can be done, but may
require developing some coding expertise. If you are familar with Excel
coding you are on your way in Access VBA.
Once you get the second form to 'open' you can set the form property to
'modal' and it will stay on top and will not allow the user to go anywhere
else without first closing the second form. That will solve the second part
of your question.
For the first part:
Maybe you could build a table of responses to form (or hard code the
response to form. However, every time I do this I get pounded because
'they' want to change the allowed responses)
e.g. Question Response DataFormToOpen
10 1 Form10_1
10 2 Form10_2
11 1 Form11_1
Then in Form1's Question 10 'widget' (textbox, combobox, whatever) you can
set the appropriate Event to run some code.
When you exit the widget, or the widget loses focus, then open the
appropriate form (you may want to use onchange or other event)
If you have hard coded the response to form you can use something like
case select Question10.text
case 1
docmd.openform("Form10_1")
case 2
docmd.openForm("Form10_2)
end select
If you use the table approach you might do something like
dim FormRequested as string
FormRequested = dlookup("DataFormToOpen","DataForms","[Response] = " &
Question10.Text) ' find the form for the data entered
docmd.openform(FormRequested)
Note: ALL of the above is 'air code' so your specific code will vary.
Lots of luck
Ed Warren
"WillRn" <WillRn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F1687ADD-937C-4066-949C-61239051EAEC@xxxxxxxxxxxxxxxx
>I am in the process of building a test database to compile the results of
> chart audits in my hospital and I have a couple of questions.
>
> 1. Can anyone show me (or point out a tutorial) how, a particular answer
> in
> a form's control, could trigger an additional "pop-up form" that inserts
> additional data into another table and then closes when the user closes
> the
> additional data form? I figure that I can just use a query for my users to
> complete the followup data posted to the additonal data table later.
>
> 2. Is there a method like the "Case Method" in Excel whereby an answer on
> a
> control on a form could "default in" an answer on another control? I am
> not
> familiar with Access VBA programming or Macros in any way shape or form so
> please be gentle!
>
> Thanks,
>
> Will
.
- Follow-Ups:
- Re: Newbie Questions
- From: WillRn
- Re: Newbie Questions
- References:
- Newbie Questions
- From: WillRn
- Newbie Questions
- Prev by Date: RE: Date query
- Next by Date: List box full?
- Previous by thread: Newbie Questions
- Next by thread: Re: Newbie Questions
- Index(es):
Relevant Pages
|
