QBF Form

  • Thread starter Thread starter Bryan
  • Start date Start date
B

Bryan

I am creating an inventory database for certain assets.
One of the functions I would like to perform in this
database is to find and check-out items from the inventory.

I created a QBF Form and resulting Query that allows me to
look up items. The Form and Query searches for matching
items in one of the tables, and usually finds more than
one record (I have several fields you can search by, even
if you type only the first few letters).

What I would LIKE it to do is display the Query results on
the Form rather than in a seperate datasheet that opens
over the Form. Then provide a way to pick one record from
the Query results, and send that to another Form, or
Subform, for the purpose of checking out that item.

What I am trying to avoid is to make the user use one Form
to look up an item, remember what that item's stock # is,
close the Query, close the Form, then open another Form to
check it out.

Any and all help is greatly appreciated.
 
Look at the forms OpenArgs property. With that, you can open a form from
another form, and pass data as a string from the source form to the
destination. So if you pass the record ID, you can then use that ( possibly
after converting it back to a number ) to select a record on the newly open
form.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Thank you Adrian!

Is there a way to display the query results within the
original form?

Bryan
 
If I understand you, you want to have a form open as a QBF, select a record,
then switch the form back to a 'normal' form, and display the same record.
I thought if you just removed the filter ( right-click, and use the popup
menu ) that was the normal behavior. I must admit though that I dont use
the QBF form much. If the selected record doesnt 'stick'. you can easily do
it with a bit of code. Just assign a variable to hold the recordID, save it
when the record is selected in the QBF view, switch the form back, do a
FindFirst on the ID.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top