Search results

You are me hero. I've been reading all kinds of post today and couldn't figure this out. and your link made it crystal clear. I changed ot on On Current instead On Load, but it works perfectly! Thanks again. S

On my form ECOs When my text box RELNUM is > 0 I want form properties AllowEdits set to FALSE. When RELNUM is null I want form properties AllowEdits set to TRUE. This must be possible, but not entirely sure where to start. Since I can scroll through records in this form I'm thinking I have to...

Ok I have read and given thought to what you all recommend. If I make the following changes Add Record ID as autonumber PK Keep Project Field Keep Suffix Field Remove EC# since it can be concantenated from project field Index the table so Project and Suffix are unique I still have the same...

Ok I think I figured this out. I added a filed suffix and now after I select the project combobox i do Private Sub p_AfterUpdate() If IsNull(Me![s]) Then Me![suffix] = Format(Nz(DMax("[suffix]", "[Table4]", "[project]='" & p & "'"), 0) + 1, "00000") End If Me![s] = Format([suffix], "00000") End...

Creating a form agianst a table with the following fields EC Project Originator Title Full description Effectivity Etc.... Easy enough to create the Project combo box, problem comes with trying to systematically assign the next EC number. When I select a Project from a combo box I want an...