Need to retrieve record using one or two fields of input

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

Guest

I have two questions, which are related somewhat but not reallly.

I want to take several data input forms I have and kind of combine them into
a tabbed setup. Am I going to basically have to combine all three froms into
one big one or do they remain technically individual forms even though they
display using one vehicle (tabbed interface)?

2. I need to be able to search my records and return a case based on a
piece of info or two. I'm not really sure how to do this. Can I modify my
individual forms (or the tabbed thing that includes them all) such that I
can fill in case number or a couple of pieces of info and then have my
database searched and the approriate case recalled with all the other form
fields completed with the case data?

I know that's possible, at least with individual forms (not sure about the
tabbed deal), but I just don't know how to go about it. Do I use the
existing form, modify it, use a query, something else?

Also, I'd like to be able to edit the record once I recall it.

Thanks for any feedback or direction.

CW
 
Disregard the "cant do this with Access" message. It is SPAM (or worse).
Follow the link at your own peril...<g>

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top