Hi. I've made a database of my films in Microsoft Access which works fine.

I was wondering if anybody knew how to make a form that you could open on the swithboard that would have an automatic search box pop up and to type in for example the name of an actor that would then work as a query and show all of the films he is in.

If anybody thinks they know how to do this I will explain more details of my forms etc.

Thanks.

create a query in design view put the fields iin the design view in the order u would like to see them. in the field that says 'actor' or w.e. type [which actor would you like to display?]

the [  ]  are paramter queries

hope this helps. you may have to design a macro to place on a command button but i think you can create a command button and the wizard has 'open query' on click in it alredy though.. should work...

quote:

---

Originally posted by may73alliance
should work

---

macros are annoying lol. i can make it search and show you what you want in a report. can it do it for a datasheet view?

with forms, i can make the tabbed menus but how do i make it so that its one form but i press a button and it goes to a completely new (form?, view? or something) because atm ive got comman dbuttons to open other forms but i want them as one. you can do it my mate has got it on his but i cant figure it out

thanks.

now onto my problem !!!

is there anyway to make a drop down box (combo box) that will only show sources that haven't been used ???

what i have is 2 tables with details in (with an ID field in both tables) and then have a third table that matches the ID's in the first table to a certain ID in the second table. i only want to use the ID from each table once (so i have "No Duplicates" on) so is it possible to have the ID not appear in the drop down list once it has been used

bloody ell     would you have to have something like [cars]![registration] = [table 2]![used] = no           sorry kinda confused

i cant even figure out how to have it so if on a drop down menu u select bmw, that in another drop down box ud have the models u sell, but only the bmw models. btw you know how to do dis?

quote:

---

Originally posted by may73alliance
i cant even figure out how to have it so if on a drop down menu u select bmw, that in another drop down box ud have the models u sell, but only the bmw models. btw you know how to do dis?

---

show me? how?

omdz. COMPLETE n00b question but how can i set the image as a BACKGROUND, i can have da image in it but not locked. so if i want to select a button it always selects the image...its really annoying. thanks

quote:

---

Originally posted by may73alliance
show me? how?

omdz. COMPLETE n00b question but how can i set the image as a BACKGROUND, i can have da image in it but not locked. so if i want to select a button it always selects the image...its really annoying. thanks

---

THANK YOU SO MUCH. my ict teacher couldnt even tell me how to do that

quote:

---

Originally posted by may73alliance
THANK YOU SO MUCH. my ict teacher couldnt even tell me how to do that

---

Thanks guys, that has worked fine.

Just one more thing... How do I get the title of the form in the form header section to automatically change to whatever name I typed into the "what actor do you....." if possible?

sorry. i cant help you with that. thanks for your help though. and helpin piss my teacher off already taught him some other rubbash so dis shud keep him annoyed. lol

quote:

---

Originally posted by kieranissafe
Just one more thing... How do I get the title of the form in the form header section to automatically change to whatever name I typed into the "what actor do you....." if possible?

---

quote:

---

Originally posted by kieranissafe
Just one more thing... How do I get the title of the form in the form header section to automatically change to whatever name I typed into the "what actor do you....." if possible?

---