Re: linking forms

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Keith Wilby" <here@xxxxxxxxx>
Date: Tue, 20 Jun 2006 09:20:33 +0100

"tomoc17" <tomoc17@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2B2ABC3E-3AA0-4313-817C-971B31956BA1@xxxxxxxxxxxxxxxx

i am wanting to create a form that allows me to make some options before
entering in using an option group. for example i want to first find a
name
then i want to find a task for that person from a range of options.
within
that task i then want to be able to enter data from a list of 4 options.
I
want to be able to do this for a list of about 50 people. My knowledge of
access generally relies on using the wizards.

Can this be done?

You might be able to do this using the built-in "filter by form" function on
your main form - if your main form contains a combo box for your tasks field
then, in filter by form mode, all available tasks would be listed for you to
choose from.

HTH - Keith.
www.keithwilby.com

.

Prev by Date: Re: Menubars and commandbars
Next by Date: Re: How to link data in one form to another form?
Previous by thread: Re: Menubars and commandbars
Next by thread: Problem related with open and close database
Index(es):
- Date
- Thread

Relevant Pages

Re: Option Group not requerying after remove filter
... Instead of using the filter property, just requery the subform after the ... You will probably need a 3rd option in your option group called show all. ... I have an unbound main form with a bound subform. ... Dim frm As Form ...
(microsoft.public.access.formscoding)
Re: Option Group filtering
... I always find it safer to use a query behind a form. ... changes depending on the option group selected and then set the ... I have a 3 way option group whose buttons filter the forms recordset. ... Private Sub optBusiness_Filter_AfterUpdate ...
(microsoft.public.access.forms)
Re: Option Group not requerying after remove filter
... My goal is to have the filter button and the ... option group work independently. ... Instead of using the filter property, just requery the subform after the ... Dim frm As Form ...
(microsoft.public.access.formscoding)
Re: filtering a field defined as Yes/No
... filter the form based on various criteria. ... the remaining option groups based on the FCSI_Closed option group. ... The stCriteria is defined as a string as my ...
(microsoft.public.access.formscoding)
RE: auto-select subform
... Private Sub cmd_select_subform _Click ... I have taken off the filter and I have removed the the popup message. ... To check the Option Group options open the form in design view and select ... determine which sub-form is opened. ...
(microsoft.public.access.forms)