Form/Subform Access 2000

R

Robbie M

I hope this is simple - I have a form containing a couple text fields and a subform. When I enter data, the resulting records in the table are: 1 record with form data, but missing any subform data; and then multiple records missing the form data, but containing the subform data.

What is causing this and how do i fix it? Thanks!

Robbie M
 
R

Robbie M

I have still not figured this one out on my own - any assistance will be greatly appreciated! Thank you.

Robbie

----- Robbie M wrote: ----

I have further isolated the problem. I actually have 3 subforms - 2 of which have multiselect listboxes and 1 that is not multiselect. The one that is not MultiSelect results in a record with all the data I expect from the form and the subform.

The two subforms with MultiSelect listboxes result in one record with no data from the subform, and multiple records (those selected) with no data from the form. I programmatically set the missing form data, but I don't understand the one record with no data from the subform. Can anyone explain it to me? Does anyone have a way to prevent creating this record?

Thanks.

Robbie

----- Robbie M wrote: ----

I hope this is simple - I have a form containing a couple text fields and a subform. When I enter data, the resulting records in the table are: 1 record with form data, but missing any subform data; and then multiple records missing the form data, but containing the subform data.

What is causing this and how do i fix it? Thanks!

Robbie M
 
R

Robbie M

I know I'm missing something basic - I am a new user. I sure could use some tips. If I haven't provided enough information please let me know. Thanks.

----- Robbie M wrote: -----

I hope this is simple - I have a form containing a couple text fields and a subform. When I enter data, the resulting records in the table are: 1 record with form data, but missing any subform data; and then multiple records missing the form data, but containing the subform data.

What is causing this and how do i fix it? Thanks!

Robbie M
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Copy previous record into form field 0
Adding data to MS Access from csv file 0
First Subform record gets modified when closing form 3
Set focus in a specific record within a subform 1
How do I clear a form? 0
Highlight rows in a subform datasheet view 0
Testing Subform Records to make button visible 1

Top