Listing In Unbound Form

P

PedRocK

New member

Local time

Today, 06:34

Joined

Feb 12, 2005

Messages

8

• Feb 18, 2005

• #1

hi

im using Access 2003,

please check the attached file.

i want to create an unbound form, just to do a search between tables

as you can see in the form1 there is ClientName combo box,

where i want to select any value of client to list me the product
or products that this one Client bought.
i know that this will be maybe an event procedure "After update" of combo0

please advise if i am picking the values of combo or listbox from the right
table or query. and what code in my event procedure can i use

Thanks in advance.

 

Attachments

• RB1.zip

  66.4 KB · Views: 120

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 04:34

Joined

Jul 9, 2003

Messages

17,447

• Feb 19, 2005

• #2

Is this the sort of thing you are after ?

 

Attachments

• RB1a.zip

  20.3 KB · Views: 153

P

PedRocK

New member

Local time

Today, 06:34

Joined

Feb 12, 2005

Messages

8

• Feb 20, 2005

• #3

this is it

yea thanks alot

 

M

modest

Registered User.

Local time

Yesterday, 23:34

Joined

Jan 4, 2005

Messages

1,220

• Feb 20, 2005

• #4

That's all you wanted? The way you described it, I thought you needed something else. Glad to see you got it though.

 

P

PedRocK

New member

Local time

Today, 06:34

Joined

Feb 12, 2005

Messages

8

• Feb 21, 2005

• #5

well the way you listed was much more simpler than i was thinking, since i was more into coding.
thanks again