If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combi box data entry
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 |
#2
|
|||
|
|||
Combi box data entry
Tip #16: Data in a combo box control on a continuous form/datasheet
disappears http://www.fmsinc.com/free/newtips/a...ccesstip16.asp http://www.rogersaccesslibrary.com/d...nSubform.m db Contributed by Sandra Daigle (3/10/2006 in microsoft.public.access): http://groups.google.com/group/micro...a00e1deccf74f? “…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/ __________________________________________ "Saintsman" wrote: 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 |
#3
|
|||
|
|||
Combi box data entry
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 -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Tom Wickerath" AOS168b AT comcast DOT net wrote in message ... Tip #16: Data in a combo box control on a continuous form/datasheet disappears http://www.fmsinc.com/free/newtips/a...ccesstip16.asp http://www.rogersaccesslibrary.com/d...nSubform.m db Contributed by Sandra Daigle (3/10/2006 in microsoft.public.access): http://groups.google.com/group/micro...a00e1deccf74f? ".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/ __________________________________________ "Saintsman" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|