user prompt

  • Thread starter Thread starter Lauren B
  • Start date Start date
L

Lauren B

I have an option for my users to set default preferences; however, they must
input several fields of information. What is the best way to create a small
box that pops up when the "set default preferences" is clicked. I then need
the inputed information to save to the appropriate table.

Thank you in advance for any assistance.

LB
 
hi,
the "small box" would be a standard form set to open when
the default preferences is checked(i assume a check box?)
if me.checkbox1 = true then
docmd.openform "frmdefaultperferendes", acnormal
end if
to update the table, a recorset maybe.
Dim Dbs As Database
Dim rsD As Recordset
Set Dbs = CodeDb()
Set rs = Dbs.OpenRecordset("Mytable", dbOpenDynaset)
With rsDisc
.AddNew '(or update if already set)
!Mytable_ControlNbr = txtControlNbr
!Mytable_ItemID = txtItemID
!Mytable_Description = txtDescription
.Update
End With
rsDisc.Close
Dbs_Disc.Close
MsgBox (" something got updated. now what?")
 
Back
Top