I am using form to pull up data in the subform, but it keeps chan.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was wondering if someone could help me out with an Access Db problem.

The issue seems to be with the form which has two combo boxes for selection
from a list and are feeding these to a subform to display the resulting data
based on these selections above.

When I do a selection it writes back to the table. Thereby changing the
records in the table. What I need is that it should bring back the required
data set based on the selection, and not alter or change these as its doing
right now.

I would very much appreciate if you could point me in the right direction
(where I might be going wrong!), and thanks in advance for your input.
 
MSA said:
I was wondering if someone could help me out with an Access Db problem.

The issue seems to be with the form which has two combo boxes for selection
from a list and are feeding these to a subform to display the resulting data
based on these selections above.

When I do a selection it writes back to the table. Thereby changing the
records in the table. What I need is that it should bring back the required
data set based on the selection, and not alter or change these as its doing
right now.

I would very much appreciate if you could point me in the right direction
(where I might be going wrong!), and thanks in advance for your input.
Click to expand...



The combo boxes that are used for searching should be
unbound (nothing in their ControlSource property). Since
these combo boxes are used for a different purpose from the
form's data controls, it's common to put them in the form's
header section and set their BackColor to a different color
than the data controls.
 
Back
Top