I am not even sure if this is possible, but here goes…
I have a main form named frmWORKORDER, |
which has a combo box selecting Department from tblDEPTS
The main form has a subform named subfrmAPPROVALS,
which has a combo box selecting Names from tblCONTACTS
What I need is…
If a certain Department “Marketing, Special Events” is selected in
Department combo box on the main form , to have 5 specific names
automatically selected in the subform , Name combo Box with an ability
to select more if needed,
as well as, if “Marketing, Special Events” is not selected in
Department combo box on the main form, to have 3 specific names
automatically selected in the subform, Name combo Box with an ability
to select more if needed.
I am somewhat of a newbie so coding is not my strong suit.
RE: How to select subform records? ... Pass that info from the subform control to the main form after the ... When selecting multiple records in a datasheet or continuous form, ... the primary key any record beyond the first of these multiple records ... the bottom to the top, then the first "current record" will be the bottom row ... (microsoft.public.access.formscoding)
Re: Runtime Error 3021 ...Private Sub Combo26_AfterUpdate ... >>>> you think you're selecting is not what the value of the combo box is. ... >>>> What is the Row Source query for the Combo26 control? ... >>>>>I have created a form and subform with the wizard. ... (microsoft.public.access.formscoding)
Re: Add record, then show it on the form ... I would like to perform through code the equivalent of selecting the new item from the combo box. ... I can in fact add the new line item record (the order detail on the subform) using the Insert SQL I posted originally. ..."Evi" wrote in message ... line item to the purchase order line items table. ... (microsoft.public.access.formscoding)
Re: Back Ground Color Manipulation Throught Options ... I get some sort of off-white background.... > background color choice for web pages correctly. ... This ability is crucial to my use ... > and this is reduced by selecting certain colors for the ... (microsoft.public.windows.inetexplorer.ie6.browser)
