Search results

Thanks!

The value specified by CurrentRecord corresponds to the value shown in the record number box found in the lower-left corner of the form. A primary key is, for example, an AutoNumber, a field data type that automatically stores a unique number for each record as it's added to a table. Once a...

How do I get the CurrentRecord property into a query?

Excellent suggestion. I will give it a try. Thanks for your reply.

Thanks for your replies! Now I am trying this. I want all the info from the form deleted. The code below clears everything but when you go to another record, the boxes are empty. The table hasn't been changed but there is nothing in the dropdown boxes! I tried a requery after...

I had to set focus when going through the loop according to the debugger. What you say makes sense, but it doesn't work that way! Anyway, here is the code after I got through with it. It clears everything but the items in the dropdown listboxes. How do I get it to do that? Thanks for your...

This code is for this situation: a user goes back to a saved record (thus, undo in the before update event is no longer possible) and changes a programmatically-required control (i.e., the field is not made required in the table). The code works EXCEPT for when it gets to MyControl.CheckBox...

I am now using the code below, but it still gives me problem, if the user cancels and goes to the previous record, that there is still a record there with an incorrect order number. I can make the function delete the offending record, but that is a bit drastic and makes users feel odd when...

Unload vs close I believe the unload event comes before the close event. You can cancel an unload event but not a close event.

This is a global variable question. When the user clicks exit, I do not want to exit unless a valid order number has been entered. I have used a global variable (gintFlag) to try to branch the Sub Form_Unload. E.g., if the user clicks exit, the unload procedure calls the check order number...

jfgambit Thanks! You have saved me hours of work!

for jfgambit Nifty searcher! Thanks!

? for jfgambit On your form, what code would I use if I wanted it to find a phone number, but I just knew part of it?