I am creating a 'Delete Item' form. The user selects the Asset Number from a Combo List, this then displays the record details in the relevant field. The user then enters some details in the Delete fields, They then click on the Delete record, which actually just saves the record in the table with the Check box 'Deleted Record' set to true.
What I want to happen is that the asset number combo box at the top of the screen will then requery itself. I have changed the query to accomodate the fact that the I don't want to see records that have the 'Deleted Record' set to true.
I have a sneaky suspicion thet Requery is the way I should be heading but the help file is not very useful.
Bottom line, is there a way to invoke a requery on a combo box on the fly while the form is still open so that it re-populate itself.
Anybody have any ideas or suggestions?
What I want to happen is that the asset number combo box at the top of the screen will then requery itself. I have changed the query to accomodate the fact that the I don't want to see records that have the 'Deleted Record' set to true.
I have a sneaky suspicion thet Requery is the way I should be heading but the help file is not very useful.
Bottom line, is there a way to invoke a requery on a combo box on the fly while the form is still open so that it re-populate itself.
Anybody have any ideas or suggestions?
