Recent content by balpers

Thank you for the response. I still can't figure out what is going on, but I think I have found a workaround. 1. Create the combo box with the wizard. 2. Hang the following code on the "After Update" event of the combo box: ' Find the record that matches the control. Dim rs As Object Set...

This is really strange. I've done some further checking. I have found that the behavior varies from form to form in the same database. Example: I have two single-table forms that reference the same table. This table is on the "one" side of a one-to-many relationship. The forms are almost...

In form design mode in some databases, the combo box wizard displays "I want the combo box to look up the values in a table or query." This is the option I need. In other databases, this option doesn't appear in the wizard. I can't see any difference in the databases that would produce...

You just saved me a lot of time. My IT department blocks everything and tries its best to impede all work. I just had to find a sneaky workaround to be able to deal with image files. Best, Burt

I'll explore this. I didn't know the site existed. Thanks, Burt

Bob, Thank you. I just tested it and it works like a charm. Now all I have to do is to try to get my head together to ask a sensible question. I appreciate the quick response. Burt

I'm new to this site. I'd like to ask a question in one of the forums, but to ask it in an intelligible way I need to embed an image to show the DB structure. When I tried to follow the instructions in the FAQ, I found that the software would only let me upload from a URL. I could not find a...