Hello everyone,

I have the following structure:

frmMember - tblMember
frmAdmitCrit - tblAdmitCrit
frmContCrit - tblContCrit
frmAdmitCom - tblAdmitCom
frmContCom - tblContCom

When the user opens the database, the frmMember opens up. After the user enters in some member information, they can click a button that opens the frmAdmitCrit or frmContCrit forms. These forms are related to the member table. Also, if certain criteria are not met in one of the 4 sections on my admitcrit form, the frmAdmitCom will open (it is related to the admitcritid)

My problem is this, if I do not scroll forward to the next member record, then back to the member record I am entering, the frmAdmitCom will not retain the data. I know that I probably need to do some form of bookmark or requery, but I just cannot get it to work. HELP!!!!!!

My staff is going out in 2 days to do reviews based on this program and I need to get it up and running. Any help would be appreciated

Thank you,
Doug

I think the record is probably being saved, but the form is just not showing it. In some field or event a Me.Refresh should do the trick for you, but what event to put it in is the question. Maybe in the last field on the form... A little trial and error may be required. Sorry that I am not being more specific....

Thank you, I can't believe I did not think of that!!!