advice needed

[ehdoh]

I am not sure how to accomplish what I seek to do and am hoping someone on this forum can help me.

On my form, I have several text boxes, combo boxes, etc. In certain text boxes I would like to set a condition so that if a particular combination of letters are entered the user will be directed to a comment field. Whether that comment field is already on the form and just not part of the tab stop or whether it is a comment field that pops up independently to ask for the additional information to be entered and stored makes no difference to me.

My problem is that I do not know the best way to go about setting this up.

-Do I store the comments in a table? If so, my tables on the form and subform I am working with are already at their size limit, which would mean any comment fields would be part of another subform.

-Do I set up the commands for this with a macro? Through VB code? Through which event procedure??

I realise there are probably many different ways to accomplish my goal. I am hoping you all can help me sort out which way might be best.

Cheers,
E.

 

[jeremie_ingram]

This could be handled via the After Update Event. If you wnat to create a different form for the data to be re-entered or completed in you would use a comparison, then a call function for the other form to open.

if me.text1.text = "ABCD" then
DoCmd.OpenForm "Form2", acNormal, , , , acDialog
end if

this will open the form in dialog mode, so that it has focus and the user can enter the data. Add a nice lable to explain whats needed, and they could enter the data into the space provided.

I have attached a small example. Look in the code for the notations, but this is very basic. Both Form1 and Form2 are based off of the same table.

Hope this helps