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


"Bob V" <(E-Mail Removed)> wrote in message
news:%23$(E-Mail Removed)...
>
>
> 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
>
>
>
>
>

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:%23$(E-Mail Removed)...
>>
>>
>> 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
>>
>>
>>
>>
>>
>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:%23$(E-Mail Removed)...
>>>
>>>
>>> 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
>>>
>>>
>>>
>>>
>>>
>>
>>
>
>

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> 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" <(E-Mail Removed)> wrote in message
>>> news:%23$(E-Mail Removed)...
>>>>
>>>>
>>>> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>