Combo box to show selective Records!

[Bob V]

I have a table [tblAccountStatus] that has around 6 fields for receiving
payments
2 of the fields are [ClientID] (Number) and [ModeOfPayment] (Text)
I have created a query using these to fields , made a combo box using this
query ,put it on my form and made Control Source [ModeOfPayment]
Now what I would like to do is when I enter the ClientID on to my form the
query will only show [ModeOfPayment] that has been entered with that
[ClientID]
Hence when I select Mr Tom Cruise , I will get a selection my from my Combo
Box as the names of the checks I have entered under his ClientID
Hope this makes Sense...........Thanks for any Help.............Bob

 

[Jeff Boyce]

Bob

Why does it take "around 6 fields" to show payments received? What are you
putting in those fields?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bob V]

Thanks Jeff,
BillID - AutoNumber
OwnerID - Number (Client)
BillDate -Date/Time (Date)
PaidAmount - Currency (Amount)
PaymentID - Text ( Anything kept private to me about payment)
CreditNote - Memo ( Issue a sepate Credit Note)
PayNo - Yes/No ( Issue a Payment number or Zero number)
BillID1 - Number (Payment Number)

Thanks Bob

Bob

Why does it take "around 6 fields" to show payments received? What are
you putting in those fields?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a table [tblAccountStatus] that has around 6 fields for receiving
payments
2 of the fields are [ClientID] (Number) and [ModeOfPayment] (Text)
I have created a query using these to fields , made a combo box using
this
query ,put it on my form and made Control Source [ModeOfPayment]
Now what I would like to do is when I enter the ClientID on to my form
the
query will only show [ModeOfPayment] that has been entered with that
[ClientID]
Hence when I select Mr Tom Cruise , I will get a selection my from my
Combo
Box as the names of the checks I have entered under his ClientID
Hope this makes Sense...........Thanks for any Help.............Bob

 

[Jeff Boyce]

I suspect Access is confused between the ID and the ModeofPayment. It
sounds like your combobox control is bound to one, but your RowSource
indicates another.

Are any of your table fields using the "lookup" data type?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks Jeff,
BillID - AutoNumber
OwnerID - Number (Client)
BillDate -Date/Time (Date)
PaidAmount - Currency (Amount)
PaymentID - Text ( Anything kept private to me about payment)
CreditNote - Memo ( Issue a sepate Credit Note)
PayNo - Yes/No ( Issue a Payment number or Zero number)
BillID1 - Number (Payment Number)

Thanks Bob

Bob

Why does it take "around 6 fields" to show payments received? What are
you putting in those fields?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a table [tblAccountStatus] that has around 6 fields for receiving
payments
2 of the fields are [ClientID] (Number) and [ModeOfPayment] (Text)
I have created a query using these to fields , made a combo box using
this
query ,put it on my form and made Control Source [ModeOfPayment]
Now what I would like to do is when I enter the ClientID on to my form
the
query will only show [ModeOfPayment] that has been entered with that
[ClientID]
Hence when I select Mr Tom Cruise , I will get a selection my from my
Combo
Box as the names of the checks I have entered under his ClientID
Hope this makes Sense...........Thanks for any Help.............Bob

 

[Bob V]

Thanks Jeff, No Lookup codes on that form!
Sorry I have not created my combo box yet as I did not know how to filter it
to OwnerID
thanks for your Help....Bob

I suspect Access is confused between the ID and the ModeofPayment. It
sounds like your combobox control is bound to one, but your RowSource
indicates another.

Are any of your table fields using the "lookup" data type?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks Jeff,
BillID - AutoNumber
OwnerID - Number (Client)
BillDate -Date/Time (Date)
PaidAmount - Currency (Amount)
PaymentID - Text ( Anything kept private to me about payment)
CreditNote - Memo ( Issue a sepate Credit Note)
PayNo - Yes/No ( Issue a Payment number or Zero number)
BillID1 - Number (Payment Number)

Thanks Bob

Bob

Why does it take "around 6 fields" to show payments received? What are
you putting in those fields?

Regards

Jeff Boyce
Microsoft Office/Access MVP




I have a table [tblAccountStatus] that has around 6 fields for
receiving
payments
2 of the fields are [ClientID] (Number) and [ModeOfPayment] (Text)
I have created a query using these to fields , made a combo box using
this
query ,put it on my form and made Control Source [ModeOfPayment]
Now what I would like to do is when I enter the ClientID on to my form
the
query will only show [ModeOfPayment] that has been entered with that
[ClientID]
Hence when I select Mr Tom Cruise , I will get a selection my from my
Combo
Box as the names of the checks I have entered under his ClientID
Hope this makes Sense...........Thanks for any Help.............Bob