different records on form

  • Thread starter Thread starter Alec Green
  • Start date Start date
A

Alec Green

Hi

I have a form in my database that has a text box linked to QuoteID and a
combo box also linked to QuoteID, this tends to work, but there are
occasions that both the text box and combo box can show different records on
the form.

Any Ideas ?
 
text boxes and combo boxed don't show records, they show table columns.
A combo box allows a choice for data entry. I suspect the properties for
your combo box are not set up correctly or maybe you have a different default
or data entry mask for each control.

Dorian
 
When you say "show different records" do you mean that they show fields from
different records, or that you intend them to show the same field in a
record but they instead show different fields from that record? In the
combo box properties, be sure that you are displaying the row source column
that you mean to display. To check this, click in Row Source and click the
three dots to view the row source query.
 
Back
Top