Search results

Hi there, I have a lookup which selects a 'Recipient'. I need to add a check to see if this 'Recipient' (user selected) already exists within another table. If so, I need a pop-up to appear. If not, I want the user to continue unimpeded. Thanks as always!

Thank you both for your help! Rob

But in the default value, at the form level, what code would I insert then to tell the form to use a specific table's row? Thanks again! Rob

Yikes.. although I really appreciate your reply, it's a bit ahead of my VBA understanding at this point. Does it really require this much code to tell a lookup to default to a specific row in a table?

Hello everyone, This is my third question with this community, and I just want to say how shocked and amazed I am by this everyone's willingness to help people learn. I am truly thankful. But now onto question three! I have a Lookup field that possesses a ID Number and Company name, taken...

Hi everyone, What I need: An if statement which will disable out a field depending on which type of field is selected from a separate lookup. I know that is confusing, so let me explain with an example. If I have a lookup field connected to "Vegetables", "Fruits" and "Nuts". If the user...

As a quick follow up it appears as if my IT department (on a work laptop) has disabled macros for security purposes, and as is I am unable to enable this feature. Thank you for help! Wouldn't have figured this out otherwise.

Access 2010, could you provide a little more detail as to where this option is? I apologize, normally okay with finding these setings but am not seeing it. This would explain so much!! Thanks again, Rob

Hello there, I'm pretty much brand new to VBA so please bear with me. My code appears relatively simple, but it refuses to execute. Code is below. If someone could help me out, I'd be extremely grateful as I've been embarassingly stuck on this for several hours now. As you can probably tell...