Opening a new form with specific values

[ethan.geerdes]

Hello everyone,



I am working on a project. I have a table, SiteInfo.tbl. It has a list of a whole bunch of offices, phone numbers, contact information and network/equipment information about that office. I want to make two forms. One form that gives the office information and the other form that has information about the office that is chosen off the first form. how can I go about this? Would this be passing through arguments?

[pbaldy]

Sounds like:

BaldyWeb wherecondition

[ranman256]

you make a query, qsOffices, this pulls ONLY the office nums.
in a form that shows all records. put a combo box on the form header, this combo will use the query qsOffices.
when the user picks an office from the combo, the form will filter only that dept.

sub cboOffice_afterupdate()
if IsNull(cboOffice) then
    me.filterOn = false
else
    me.filter = "[office]='" & me.cboOffice & "'"
    me.filterOn = true
endif
end sub