Recent content by mistyinca1970

OK, but as I had updated. I rebuilt the form control by control and the box only appeared after adding the the on load event to open another form in the event that the recordset in the other form is >0. So the box is somehow related to the on load event after the msg box is cleared. So there is...

Well I still don't know why, but I know what it is associated with now. I started rebuilding this form piece by piece and once I added the on load event that opens a form (or not if the recordset is 0) and a msg box, that dotted frame appeared. The addition of none of the controls produced the...

To prove my point, I made a copy of the form so I can mutilate it at will (he he). I started deleting controls one by one, and then I skewed them here so you can see its not a layout.

I tried that. None of my text boxes or anything have a layout attached to them. When I right click each control and select Layout, there is no option to remove layout.

Yes. It does not show in design view. So I'm thinking it is part of the navigation form...

Can someone tell me what this red dotted box is? This is on a form within a navigation form. This shows in layout view, and it doesn't appear on any other form in the navigation form. I also do not see it when I open the target form on its own in layout view. I can't seem to select it. Any ideas?

I don't disagree with you. This was in response to Gasman stating that it works if the column is hidden. And then I did in fact adjust the column widths to accomplish it. 🤷‍♀️

Well, what I did was go to row source and I unchecked the box for Email. When I did so, the combo box no longer even had that column. Is there another way to "hide" that column. Changing the column widths accomplished the same though...

Excellent! Thanks...does this also work if the column is not displayed in the combo box? So if uncheck that column and only the person's name displays in the combo box, can I get the respective email address in the text box? EDIT Answering my own question. Discovered I can't do that, but I can...

Sorry if the title is confusing. What I'm trying to do is use both columns of a combo box in different ways. My combo box (cboSendTo) has two (visible) columns: one's name and then one's email address. Is there a way to specify the column of the combo box to use in code other than whichever...

Perfect! This works great! Thank you!

Hello, I have a query that is tied to a form that will show records based on the user's division in the org. The criteria comes from a TempVars captured at login. What value would I need to get in this field to return records for all divisions? SELECT tblContracts.ID, tblContracts.Division...

I have not. Don't know how that one works. However, I am happy to report that I did successfully add the line of code I needed to accomplish this! I was wrong in my first post. I ended up adding: TempVars ("UserDivision") = rs!Division.Value Works as intended! Thanks!

The previous scenario was setting the tempvars from the combo, but I want to restrict the access to the division associated with the user. I don't want the user to select a division and then have access to that division's records if that's not the division they wanted. This also gives me the...

Right now it is a concatenated algorithmic password; not something the user chooses himself. Once I am done testing all this, I will move to something the user is able to reset. Baby steps. (This is a learn as I go project!)