Search results

Does this do the trick? Is is it not possible to create a query that looks for the necessay projectID in the bank table. Then run a macro to see if this is NULL or not. If it is openform in add mode, if it isn't openform in edit mode and set the values from the query? I'm at work and haven't...

Okay, but does that mean I have to write a VB program? - I'm a novice and was hoping I could do it in a macro or query using the expression builder?

Hi there - I'm a beginner to access and would like to know how I can open a form in 'edit' mode if a certain value exists and 'add' mode id it does not. I posted this to macros but now think it is a query problem? I have a two tables with a one-to-one relationship. Project and bank. I have a...