Search results

Works a treat - thanks!!

I am sure this must be very simple but.... as the 'Before Update' event for a text box in s asubform in datasheet view, I perform some validation and if it fails send a msgbox then 'cancelevent' (in a macro). Although the box still has the focus, I would like the erroneous value...

I have a multi select combobox which will contain a variety of remedial actions taken to a problem e.g. cleaned, repaired, replaced, removed, adjusted etc I want to use these selections to automatically create some text so to make sense, the order of selection is important eg removed, cleaned...

Fogive me if I am missing the point, but as a new member I feel morally obliged to try to answer instead of asking!! If you are populating a 'mission' table, then indexing with no dupliactes the soldier field would prevent it. If the table is status sensitive (eg holds open and closed missions...

Thanks!

Hi! I have a subform (continuous forms) that includes a command button to perform a task for each of the individual records. However, I also get it on the 'new record' at the bottom, which is not appropriate. I would still like the user to have the opportunity to add new records so I dont want...

Hmm...... I have tried changing the column in the table to be 'required = no' on the basis I will ensure its population using form control. The 'after update' event of cb1 now requeries cb2, sets its value to null and then sets the focus to cb2 (using gotocontrol). I then wrote a litlle bit of...

Thanks for the reply! Problem is that I can only set it to null if the bound column is 'required = no' which I am trying to avoid. I assume that this also means that I have to define a 'lost focus' event (and before save etc ?) to check it has a value (and one that is valid). I guess really...

Sorry everyone - it looks like that this has been done to death, all except for this question...... I have a combo-box (cb1) from which a user selects a value (row source = a query), When the user make a choice, the 'after update' event runs a macro that performs a 'requery' on another...