Pop Up Form To Add Information When A Record Value Is Changed

lex404

New member
Local time
Yesterday, 21:27
Joined
Apr 5, 2011
Messages
7
Hey,

I have a form with two subforms on it and they are linked together so that when someone clicks on a line item in the table, the other table automatically updates to show the notes pertaining to that line item. Table 1 has the following columns: Item ID, Nomenclature, Manager, and Status. What I would like to do is have another form pop up when the status for a line item in Table 1 is changed to "submitted" so that the user can add the Item Value and Submittal date information as soon as it is changed to submitted. Is this possible? if so, how would you recommend going about doing this? any help is appreciated. Thanks!
 
Try something like

On the after update event of the status field

If me.status = "submitted" then
DoCmd.OpenForm "YourNewFormName", acNormal
end if

SmallTime
 
Forgot to mention that you should make sure the new record on the opened form relates to the specific record in your first form, I suspect the related field is 'Item ID'. If so play around with

IF me.status = "submitted" THEN
DoCmd.OpenForm "YourNewFormName", acNormal, , Item_ID = Me.Item_ID, acFormAdd
End IF

SmallTime
 
Also try to avoid using empty spaces when naming fields as it makes coding a little more tricky and also use and stick to a naming convention.

here'r one to consider
http://en.wikipedia.org/wiki/Leszynski_naming_convention

but you could make your own. the important thing is that you always stick to whatever convention you use.


E.g. the field name on your forms could be TxtItemID instead of Item ID


Take care
SmallTime
 

Users who are viewing this thread

Back
Top Bottom