SubForm data wont show whem change cbobox from Parent form

  • Thread starter Thread starter Jenny Kwon
  • Start date Start date
J

Jenny Kwon

Hi,

I have a parent form contains several subforms. The
parent form is loaded using commend
DoCmd.OpenForm "AddProduct", , , , acFormAdd,. At first, I
enter product information to the form, then I enter other
data to the sub form. However, if I go back to the parent
form and change any combo box value from there. Any data
I entered to the subform cannot be displayed. When I query
my database (sql server 2000, I use ADP), the data IS
there.

Anyone have any idea?

Thanks!
 
Sorry that this is unrelated but you sound like you know what you're doing when it comes to forms.

I have a form for data entry, and when I hit the save button on the form, the data is saved into two separate tables. This is a good thing for me, however, I would like the navigation button on the bottom of the form to change from 1 record to 2 records. The navigation buttons aren't highlighted at all, but they are present.

If that issue isn't solveable, is it possible to retrieve the data from the two tables and put them back into one subform. The problem here is that when the data is entered, it's entered into one sheet, but when saved, each entry is saved into individual records. So the subform I've created doesn't show all the data I entered into the one form. I think it might be a problem with the Save VBA code I have.

Thanks for any help.
 
Back
Top