how do i open a query\form from a listbox

[dotan]

i called both textbox and query "clinet_serch'' so i need to write in the textbox

=DLookup("clinet_serch", "clinet_serch")

well i also dont know how to use the VBA oppiton you told me so ill need you to explain agian, ill deal with the teacher

[TheShabz]

No, the second one in the () would be the field name from the query you want to display the data of.

I can't explain the VBA part any simpler than how I already did.

[dotan]

well i wrote

=DLookUp("clinet_id","clinet_serch")

and now when i try and type numbers in view it says it cant be edited....

[TheShabz]

You dont type in the numbers there. This is your display textbox. Your data entry textbox is the one that's being used by the query.

To be honest, this is stuff you should be picking up in your classroom. I suggest going to your teacher for help on this. I cant really teach you how to use a form and navigate it.

[dotan]

i think you didng quite get me i dont care if i use a query or not i just thought i need it but i didnt get how to do it on my own, what i want this all thing to do is that i open my clinet form write an id number on a textbox (or somthing else it dosent even matter) and then it will navigate to the clinet which i wrote hes id in the textbox and it needs to be in the same form/
its not homework by my teacher, we didnt learn it at all its somthing i want to do and my teacher dosent explain, she sends to google, google found this forum

[TheShabz]

The query is needed. I understand what you are trying to do. That's how you do it. Is this a college teacher? If she's sending you to google, you go to your dean. I honestly dont know any other way of explaining it. My apologies for not being able state it in a way you can succeed with.

[ajetrumpet]

I'm still monitoring this, Shabz.

just kidding!

dotan, I might be able to help, if you're not sick of this thread already...if you need another type of explanation, that is.

[dotan]

The query is needed. I understand what you are trying to do. That's how you do it. Is this a college teacher? If she's sending you to google, you go to your dean. I honestly dont know any other way of explaining it. My apologies for not being able state it in a way you can succeed with.

im in high scholl
i cant go to the dean because she runs all the deparment of cumputers in the school so if she dosent like you, you'r out

I'm still monitoring this, Shabz.

just kidding!

dotan, I might be able to help, if you're not sick of this thread already...if you need another type of explanation, that is.

Im not giving up this easly XD
ok so i did the DLookUp in the textbox and i cant edit it
what do i do now? (i have never touched VBA so i need you to explain step by step)
thank you guys you rock any other forum will give up in this point

[ajetrumpet]

why don't you just upload what you've got to us and say 'one more time' what you want.

it's extremely easy for people to do it themselves so they know exactly what to say. make sense?

[dotan]

do you want the accdb file? or a picture?

[ajetrumpet]

do you want the accdb file? or a picture?

well a picture doesn't do me that much good, considering I said this:

it's extremely easy for people to do it themselves so they know exactly what to say

yes, the file.

[dotan]

http://www.fileflyer.com/view/yu0wECf

[dotan]

have you forgaten me?

[ajetrumpet]

have you forgaten me?

yeah sorry bud. I forgot. I'll try and check your stuff out tonight ok? thanks for saying something!

[dotan]

yeah sorry bud. I forgot. I'll try and check your stuff out tonight ok? thanks for saying something!

more than ok, thanks