Shoutbox

quote:

---

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

---

don't worry !! i kick my comptuin teachers arse when it comes to database's

anyway back to 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

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?

---

that this mite be possible by changing the properties of the form is vb editor !!

i'll mess around, and get back to you

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?

---

Anyone know how to do this or not? Thanks.