Re: Forms not working together well
- From: "Al Camp" <anon@xxxxxxxx>
- Date: Mon, 9 Jan 2006 17:27:44 -0500
With the info you've given, I think you just need to do an Update or Refresh
on form1 before opening/creating subform2.
Probably the data you just entered in form1 has not updated to the table
yet, so a combo query based on that field would not show that new entry.
I'm a bit unsure why you're "linking" the 2 subforms by a text Decription
field. They usually should be linked via a unique identifier (key field) on
the main form. Sounds like you'll end up with duplicate Descriptions, and
cause subform records from other records to appear in your subform.
Maybe I misunderstood...
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
"Mike101338" <Mike101338@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:893CED92-F85B-428B-AE09-BFD417AD30FE@xxxxxxxxxxxxxxxx
>I have a series of 3 forms. The first form is primarily data entry. The
> person entering data makes the determination if the second form is
> necessary.
> If the information requires the second form, the data entry person checks
> the
> box stating the next form is necessary. I wrote the macro for the second
> form
> to automatically open.
>
> The two forms are linked via a control box I'll name "description". On the
> second form, I'm doing a drop down menu to force the data entry person to
> select from the list of "description" entered within any of the first
> forms.
> Everything works well, except I can not get the content in the
> "description"
> from form 1 to be available as a choice on form 2 until after I've
> finished
> and closed form 1.
>
> Any thoughts on how to get past this?
.
- Prev by Date: Re: Populating the data of two Textboxes into One textbox
- Next by Date: Re: picture on form
- Previous by thread: Re: How do I send an outlook form as a message?
- Next by thread: Re: picture on form
- Index(es):
Relevant Pages
|
