Is there anyway to blank a text box on a form

thankx, ok, but if i dont use the dlookup is there another way of getting the topicID from the title?
 
You would use it to get the topicId from the title, boB is merely saying u dont set that in a combo box
 
thankx, ok, but if i dont use the dlookup is there another way of getting the topicID from the title?

I'm not sure what you mean. If the combo box is bound to Topic ID and you have the query that currently exists as the underlying Rowsource for the combo box, whenever you move between records the combo box will display the text (not the topic id), but the value of the combo box will be the topic id.
 
It did for me when you change the CONTROL SOURCE of the combo box to TopicID ( just use the drop down to select it). Leave the ROWSOURCE the way it is.
 
ok this is funny but i dont have a ROWSOURCE box?
 
ev09.png
 
yeap, sorry had a blode moment there, i been working on this for to long, lol sorry
 
ok, studding carefully then what is the difference between name and userID and topic id and title because the topics one works fine and add the value found to the database were the userID add to the database at 0 always
 

Users who are viewing this thread

Back
Top Bottom