Search results

I honestly don't know if it's possible to go down more than 2 subforms in this manner. I've never tried... but it just seems like an absolute headache lol. Have you tried initiating code on an event for the subform in question? That way you may be able to refer to the form control more easily...

I don't think it's possible to Anchor the different sections of a form... technically speaking... But I kind of feel like maybe it has something to do with the Height of your Details section... it sounds like you may have your Auto Height set to Yes. Here's why: Essentially increasing the...

You are welcome MilaK. spikepl is more knowledgeable than I am so following his lead might be the way to go, as he's already given me a thing or two to ponder in 2 separate replies haha. But! Discussion is the key to learning so ... First and foremost It sounds like you may have figured...

Below is the Function you can use to validate your users inputs against the data in your table. You may not need to do this, but it can't hurt to have the option available. We start by naming the function and setting the 5 inputs we want to validate against our data. Private Function...

There's probably a couple easier ways to solve this... for instance. If the user hasn't saved the record you could pop an error message when they try to start entering lab data for a patient that doesn't exist. Also, I don't know that i'd trust users to just be allowed to enter data into the...

Alright I read through this because I feel like i've had to do something similar. It looks like you may have solved it but I thought i'd throw my 2 cents in. When I need to reference the last record I've added to a table, especially if I don't need it for more than just the immediate task at...

No problem, I'm sorry it didn't work for you. I was sort of pondering this issue today because I really only use VBA to solve my problems, so I was trying to think of a non-vba way to get what you need. What if you solved this in such a way that instead of throwing an error when a user creates...

I'll admit up front that i'm not as good as many others on these forums, but if I were you this is how I would tackle the problem. (If anyone has better advice, by all means let me know!) First I would create a query based off your table that gets just Document, Supervisor, and Month from...