Re: Combo box data vanishing
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 14 Aug 2007 10:57:18 -0600
On Mon, 13 Aug 2007 20:14:01 -0700, kasab <kasab@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
In a continuous form, I have a task field combo which is used to filter
options for a
position combo AND a materials combo. The position combo works fine, and
materials combo works fine in the current record, but once I move to a new
record, the entry in the materials combo vanishes. It's saved to the
appropriate table (options), but just looks (at best) unprofessional, hard to
edit, etc. Also, the edit form built from the same setup displays a dialog
when opening that asks for the task and only displays the material selected
for the same task as entered.
All combos were set up interactively using SQL in the row source.
Please post the code and the SQL.
My guess is that the second combo is dependent on the first, so that when you
move to a different record, the second combo's row source no longer returns
any records. This can be a hassle to solve; one way is to create a textbox
displaying the desired value (from DLookUp or by basing the form on a query
joining to the Materials table); carefully superimpose the textbox on the
text area of the combo box. Be sure that the textbox is locked, disabled, and
not a tab stop.
John W. Vinson [MVP]
.
- Prev by Date: Re: can I make 3 tabbed forms?
- Next by Date: Re: Show logged on employee on a list box
- Previous by thread: Help with follow hyperlink method
- Next by thread: Re: Show logged on employee on a list box
- Index(es):
Relevant Pages
|
