Generation of new subform record based on combobox AND main form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have an unbound combobox (cboDOVSearchChart) whose row source is a query
that brings up all of the dates associated with a particular medical record
number. It consists of two columns, chart ID (hidden), and date. Each
combination of MR and date yields a unique (autonumber) chart ID. The first
column serves as the link field to associate with a subform that is based off
of chart ID and contains all of the chart information.
Is there any way to use the NotInList event for this combobox to create a new
record in the subform that will contain the next autonumber for Chart ID with
the MR number from the main chart and the date of visit that is entered in
the combobox (and then display this record)? The table (Patient_Visits) off
of which the subform is based has both MR and date of visit as required
fields; could this be causing the problem?
Thank you in advance for any direction/advice you can offer.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200708/1

.

Relevant Pages

  • Re: Form auto-fill linking
    ... You say "the combobox has two columns", but the effect of the code, which resets the RowSource property of the combobox, is to change that to only one column. ... Just the Chart ID, Date of Visit, and Medical Record # fields. ... and then enter this query as the Row Source property of the Combo16 combobox. ... In design view of the Patient Information form, look at the Properties of the subform. ...
    (microsoft.public.access.forms)
  • RE: Generation of new subform record based on combobox AND main form
    ... It consists of two columns, chart ID, and date. ... column serves as the link field to associate with a subform that is based off ... Is there any way to use the NotInList event for this combobox to create a new ...
    (microsoft.public.access.formscoding)
  • Change minimumscale with the change event of a combobox
    ... I have a chart in a a worksheet in a workbook and there is a combobox on the ... Private Sub ComboBox1_Change ...
    (microsoft.public.excel.programming)
  • RE: Multiple Charts
    ... LinkCell just represents the cell that the Combobox ... I was able to create a dropdown list where I can pick ... I need to be able to have one chart, then a dropdown (or some selection) ...
    (microsoft.public.excel.charting)
  • Re: Custom Toolbar in Chart
    ... I'm not sure what you mean by "I just can't get a ComboBox in a Toolbar ... active only when a chart is... ... If activechart is nothing then ...
    (microsoft.public.excel.charting)