Viewing data in previous records in continuous form view

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

Guest

I am using a database to record work orders for a small plant. I am using
two combo boxes with the 2nd being limited by the selection in the first
combo box.

I want to print the form for uncompleted work orders but the content of
combo box 2 only shows when you you are on that record. The records before
and after the record I am on are blank, but it does record them in the
database and what was selected shows when I return to that record. I looked
at the Support knowledge Base #208866 and either I am slow or it didn't
really apply. I went with the combo boxes to make later queries easier to
determine equipment repair cost since many were typing different criteria
(ie. Pump1; Pump#1; Pump #1).

When I set the form up, I checked the the view block in field name of the
row source expression. Everthing else seems to work but this. I've spent
two days on this and any help would be greatly appreciated....thats!!!!!
-- John
 
John,

First of all, I would recommend you set up a Report for the printing out
of this information. Whereas in theory you can print from a form, it is
not really the purpose of forms, so it is hard to get exactly what you need.

I guess one way around your dilemma is to use code on the Exit event of
the 2nd combobox, to set its Row Source to the whole list, not filtered
acccording to the entry in the 1st combobox.
 
Back
Top