Form Search

[Dinger045]

I have this information, that is a data dump from a system that we have. I know how to create queries to pull out specific data from this specific set of information, but what I am looking for is a way to Set up a form, to be able to type in the OUTLET #, and have all relevant data be displayed in chronological order below.

Like I want to type the outlet #, then have it show me the outlet information like, address city state zip.....but then also show me the other information like meter-totalizer-credit-loyalty etc....by the dates that it happened on.



Attached you will find the data....is there a way for Access to do this, or is this not the route I am looking for? Any help would be greatly appreciated.Attachment 24394

[davegri]

Attachment 24398
Maybe this is what you need...

[ranman256]

in a form bound to your data, in the form header, put a text box, say: txtFind
also put a subform in the header to show the address of the outlet. Build this single record subform.

Enter outlet# in the text box, then in the AFTERUPDATE event, filter the data

sub txtFind_afterupdate()
  if isnull(txtFind) then
      me.filterOn = false
 else
   me.filter = "[outlet#]=" & txtFind      'THIS ASSUMES ALL OUTLET#s ARE NUMERIC ONLY
   me.filterON = true
end if
end sub