Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2015
    Posts
    4
    Provided Answers: 1

    Answered: Subform no longer showing new records

    Hi folks,

    I have a continuous subform, that was once happily accepting new records.

    The subform is based on a table, and currently has three bound fields.
    Previously it had two bound fields.
    Two of the fields use query lookups (one of which was added).
    The third field is an inputted number.

    Previously when I entered data into the fields row, a new row would automatically insert.
    And when I looked at the form in layout mode, it showed a continuous form with lots of rows.

    Suddenly that has stopped.
    I now longer see a new row once I begin entering data into the row.
    And in layout mode, I only see one row.

    Here's an illustration, including the form's properties: http://snag.gy/rscff.jpg
    (and I've attached it)

    From memory all I did was add the second lookup field.

    Any suggestions as to what might have happened, and how I can get it back to the way it was?
    I'd rather not use code, because that generates a bunch of issues.

    Many thanks in advance,
    Chris
    Click image for larger version. 

Name:	rscff.png 
Views:	5 
Size:	21.4 KB 
ID:	16432
    Last edited by koitaki; 07-09-15 at 05:48.

  2. Best Answer
    Posted by koitaki

    "Ok, its working now and I think I can provide some kind of explanation...

    I have a combobox on the Mainform for ConsultantID that uses an event code to set the value on the subform for the ConsultantID.
    Both comboboxes are named cboConsultantID.

    My event code on the main form combobox was referring to ConsultantID on the subform, and setting the value for that (ie. the field name).
    I changed this to refer to the cboConsultantID (ie. the combobox name).

    That seems to have done the trick.

    Not sure at all why that is the case...perhaps its something to do with the combobox events need to be triggered before a new record is triggered.

    Chris"


  3. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by koitaki View Post

    ...when I looked at the form in layout mode, it showed a continuous form with lots of rows...

    ...in layout mode, I only see one row.
    That's because you have the Data Entry Property set to Yes; set in this way it only allows New Records to be added, it does not show previously existing Records.

    I suspect that the 'not seeing a new, empty Record being generated' is caused because the form Continuous and may not be long enough to show a second Record.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #3
    Join Date
    Jun 2015
    Posts
    4
    Provided Answers: 1
    Ok, its working now and I think I can provide some kind of explanation...

    I have a combobox on the Mainform for ConsultantID that uses an event code to set the value on the subform for the ConsultantID.
    Both comboboxes are named cboConsultantID.

    My event code on the main form combobox was referring to ConsultantID on the subform, and setting the value for that (ie. the field name).
    I changed this to refer to the cboConsultantID (ie. the combobox name).

    That seems to have done the trick.

    Not sure at all why that is the case...perhaps its something to do with the combobox events need to be triggered before a new record is triggered.

    Chris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •