Search results

thanks its working now .

Its working now , thanks man ! thanks alot ! and thanks again ! .. and again !

no the query is not the forms rowsource ! I just want to grap the show_id value (from thiis query) in accordance of the selection he/she makes in the form and place it in a textbox! hmm !?

that is exactly what I want to do , I know how to bind it to a combobox through the rowsource , but how do you do it with a textbox ?

its perfectly working now , thanks alot

okai basicaly I am running the form "z" and z is using this query: SELECT TblShow.SHOW_ID, TblShow.FILM_REF, TblShow.SHOW_DATE FROM TblShow WHERE (((TblShow.FILM_REF)=[forms]![z]![combo0]) AND ((TblShow.SHOW_DATE)=[forms]![z]![combo3])); and after evaluating the appropriate record , the...

same thing .. hmmm is it complaining because I am making a refernece to a query which uses the same form it self ?

hallo there guys, first got to thanks everyone on this forum, I have registered yesterday, since then been always in here .. :o) I have a smal problem in vb , the thing is , I am trying to store a value from a query(which has a reference to a combobox from the form). This value should be stored...

Thank you ! thank you guys fizzio and PaddyIrishMan ... everything is workin now, thnks to you guys , thanks again , and again ! :o)

thanks alot! everything is almost working ! the only thing remaining is that when a value is assigned to the listbox, the bound column should be stored in a textbox how can I do that ??? I have manage to do it on the afterupdate event, but for some strange reason this would only do it if I...

thanks man ! yea , things stated to work , but still have some problem with another combobox, this combobox required 2 fields to identify an unique record , hmm is it possible somehow to have 2 bound columns ? thnks again ...

just wanna say that this forum is really great ! and so many ppl helping out , thank you everyone !

oki , thanks alot man ... really appreciate it !

First of all , Thanks alot man, it worked ?? I used 2 diffrent methods none would work ... and I knew there was something ridiculous behind the error .... anyway thanks alot .. but to be honest, it doesnt fix all my problem .... if you take a look at the booking for , the whole booking form...

hallo there ... I have a form called booking . in there there is a combobox with 2 column ! film_ref , Film_Title and then I have a listbox in the same form in the rowsource of the listbox I have : SELECT tblShow.SHOW_DATE, tblShow.SHOW_TIME, * FROM tblShow WHERE...

sure here is the 2000 converted version (thanx alot) : www.chuchu.plus.com\db.zip

Thanks alot for the effort everyone ..! well for whom ever is intressted in my problem here is the link for the zipped .mdb file .... the form name is booking , if yuo try to press add booking , see what happens !! the same error over and over again always ! :( I have tried my method fizzios...

hmm , I appreciate your help, but this seems that this doesnt want to work !??? I am really pissed of man , this is suppose to be something really easy !! grab the value from a field in a accordance to the criteria then if 0 then success else NOO! this just doesnt want to work ! Thanks alot...

thnx for all the help to begin with. And actually the relationship between tblshow and tblbooking is one to many (one show can have many bookings) now then, you said : I have not managed to create a Query off of the tblFilm to just return these two fields , I mean I tried to set...

under Onclick Event !