Search results

This seems to break it. :( I deleted a few records, and the dropdown went crazy... (showing totally unexpected AIN values)

I just gave it a try, and it always gives me the record with AIN one more than the selected one. For example, if I select AIN=1367, the dropdown shows 1368. I was also going to check what happens if the AINs weren't sequential.

Thanks for checking. Does that version of the code still work if after you get to a different record by selecting either the buttons on the left or an item from the dropdown, you would then hit the Next button at the top (a few times)?

Okay, thanks. I see it now. The only thing I could come up with is that control is probably corrupted. As a quick test, I added my own dropdown in red, right next to it, and the new dropdown seems to work fine (I think). Could you please verify? Thanks!

Okay, as @Gasman said, I removed the Load event, but I still don't see the problem in my attached updated file.

I'm on my phone right now, but I didn't know I had to comment out a code to reproduce the problem. Which code was that and why comment it out if leaving it in doesn't cause any problems? I'll check it again when I get back in front of a computer.

I was finally able to download your file to take a look. Unfortunately, I may have misunderstood the problem as I don't seem to experience what you were saying about "rounding" and mismatches in the combobox. I did, however, add a single line of code for something else. Would you please take a...

For starters, your function is not returning any value nor is it modifying the argument referenced by the calling procedure. Furthermore, I think you meant to construct Strings in your function since you're building a SQL statement.

I think it's more like "drawing."

Just curious, would it be possible as the C&R is happening, another user might attempt to open their own copy of the first accde? If so, what happens with them?

There may be a way to do what you want but probably not with a textbox; maybe with an ink object.

Hi. Welcome to AWF! In all your posts, and I admit I skipped reading some parts, I didn't see the rowsource of your combobox. Can you post that and any code you're using to update it after clicking on your buttons? Thanks.

By it I mean you can delete the existing linked tables and then create them again using the new password.

I'm not sure why the code is hanging in runtime, but you might try recreating the linked tables instead of just refreshing them.

Hi. Welcome to AWF!

You might want to annotate your images to help identify which part of the image you're referring to.

Have you tried? DoCmd.Close acForm, Me.Name, acSaveNo

@JohnPapa Pardon me, but the above two statements, taken from two separate posts (#12 & #14), seem to convey two different goals. In any case, I think you're having a hard time because you selected a trigger that means something special to Access itself, but you want it to mean something else...

I don't think you mentioned it, but did you say what was the error with your code/procedure?

I didn't read the entire thread, so this question may have already been answered. How exactly is the popup form changing the data? Is it updating the table directly, or is it simply changing the value in the first form?