Re: form question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

trevi wrote:
No, it's not a blank row. I do get a new , empty row, but before
that I get a row of data that is the last of the entries for the
table that the subform is based on. Maybe I should put some kind of
vba code in there that puts the cursor at the new row?
thanks

Are you using the MasterLink and ChildLink properties of the subform to control
what records it displays? That is the normal approach.

If the MasterLink property of the subform is set to the name of the ComboBox and
the ComboBox has no value when you open the form then the subform should not be
displaying any records.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Combobox Display Problem
    ... ' Find the record that matches the control. ... Header section of the form (subform), ... text field containing the Item Names, the Combobox comes up empty. ...
    (microsoft.public.access.forms)
  • RE: COMBOBOX - RECORDS IN TABLE
    ... What i am trying to do is to have the reports of a medicin ... So, what i want to do is enter in my PC, pick a patient ... Not a subform.. ... >> Plus, I want that after i update my combobox, on my form ...
    (microsoft.public.access.gettingstarted)
  • Re: Update subform based on Mainform combobox selection
    ... The form/subform link is entirely dependent up on ... > the subform, using code? ... > spanner in the works? ... triggered by an event of the combobox on the main form. ...
    (microsoft.public.access.forms)
  • Re: Unbound Combo box Value
    ... the Main form has a unbounded Combobox for user to pick ... The second subform within ... Private Sub Combobox_AfterUpdate ...
    (microsoft.public.access.formscoding)
  • Re: Update subform based on Mainform combobox selection
    ... The subform has a query as it's Source, and is linked to the Main form by ... the data selected in the combobox. ... > EDITED value of the entry currently open on the main form. ... >> No problem after all of mainform record completed - I can Recalc. ...
    (microsoft.public.access.forms)