Combo box to show selective Records!

  • Thread starter Thread starter Bob V
  • Start date Start date
B

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
 
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
 
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



Jeff Boyce said:
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 said:
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
Click to expand...
Click to expand...
 
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

Bob V said:
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



Jeff Boyce said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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

Jeff Boyce said:
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

Bob V said:
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



Jeff Boyce said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top