Combi box data entry

[Saintsman]

Some advice please
I have 2 combo boxes; combo1=sectors; combo2=subsectors; there is a filter
which limits selection in combo2 depending on combo1 selection
What is the best way to set up the form to allow users to add records
I have a project table recording individual projects & an associated
subsector table recording which subsectors that project is working in. Can't
seem to make datasheet or continuous forms work
Thanks

 

[Tom Wickerath]

Tip #16: Data in a combo box control on a continuous form/datasheet
disappears
http://www.fmsinc.com/free/newtips/access/accesstip16.asp

http://www.rogersaccesslibrary.com/download3.asp?SampleName=CascadingComboInSubform.mdb

Contributed by Sandra Daigle (3/10/2006 in microsoft.public.access)
http://groups.google.com/group/micr...frm/thread/e033253ffea2b09f/718a00e1deccf74f?

“…the problem you are seeing is due to the fact that there is really only
one combo control - it is just displayed multiple times. So whatever you have
for current rowsource will apply to all rows. This makes it difficult to use
synchronized combos on continuous forms. However, there is a fairly easy
workaround. To create the effect of a synchronized combo in a continuous form
create another textbox control, include the display column of the combo in
the Recordsource query of the form (join the foreign table and drag in the
column). Position and size the new textbox so that you can place it directly
over the combo box allowing only the down-arrow portion of the combo to show.

Create a GotFocus event for the textbox that only does a SetFocus to the
combo.

This will create the effect that you are wanting - the correct display value
will always show even though the value itself might not be fit the criteria
that is in effect based on the current record.

Here's a KB Article that explains the problem
(ACC2000 Combo Box in Continuous Form Shows Incorrect Data
http://support.microsoft.com/?id=208866

Here's a link to my sample database that offers several different
alternatives for displaying this type of data including the technique
described above:

http://www.accessmvp.com/SDaigle/index.htm



Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Douglas J. Steele]

You might also check my February, 2006 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html