List box to select record to jump to.

  • Thread starter Thread starter Jarryd
  • Start date Start date
J

Jarryd

Hi,

I have a form that is used to enter billing information for numerous
accounts. The form is bound to the qryBilling query, and filtered by
account number. The billing form is opened from the Employee Accounts form,
and the qryBilling query is filtered by the account number that has focus on
the Employee Accounts form. So when you open the billing form from the
Employee Accounts form, the query is filtered to only return rows that are
relevant to the Account that had focus in the previous form. This is
working well. The next thing that I have done is created a value list that
I would like to use to hop between bills in the filtered query. The list
contains all the bill numbers in the Bill field of the filtered query. When
I click a bill number I want to go to the record in the query with that bill
number. What is the best way to do this?

TIA,

Jarryd
 
Jarryd,
I use a "jump" technique to open another form related to the first form.
Let me use an similar example...

I'm looking at an order form with the CustomerID (key field) and
CustomerName of the person who ordered the product. I double click the
CustomerID, and it takes me to the Customer form (address, contacts, phone
nos, etc..) record for that specific Customer.

Private Sub CustomerID_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmCustomers", , ,"CustomerID =
Forms!frmYourCallingFormName!CustomerID"
End Sub

You'll "jump" to the specific Customer record (in filtered mode), make
any changes if necessary, and upon closing the Customer form you'll return
right back to the "calling" form you came from.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Back
Top