Recent content by theDBguy

Hi. Welcome to AWF!

Have you checked out the Name As statement? https://learn.microsoft.com/en-us/office/vba/Language/Reference/user-interface-help/name-statement

Check your records to make sure they don't contain any illegal characters for filenames.

Hi. Welcome to AWF!

Take a look here. http://allenbrowne.com/ser-57.html

Hi. Welcome to AWF!

So, are you trying to add a single or multiple new records in one go? If only one record, then you don't need a loop (Do While).

What is the value in Me.cboInvReversal? When you filter the records, how many records do you end up having? If more than one, are you saying to want to create that many records?

To add a record, you would use .AddNew instead of .Edit

Hi. Welcome to AWF!

Hi. Glad to hear you got it sorted out. Good luck with your project.

Hi. Welcome to AWF! Instead of hiding the form, maybe you could try resizing it to a very small size that's it's nearly invisible. Check out the MoveSize method.

Hi. Welcome to AWF!

Glad to hear you got it sorted out. Good luck with your project.

Have you tried using the Format property? Just a thought...