Pop-Up Box

[CodeCracker0291]

Basically I would like a button to open a pop up box so I can type info in it. I want it to look like a seperate form but the info is still held in the main form...If I worded that confusing.. Let me explain.

I have "SBS" as my table. It has all my cells with info like name, purchase date,etc. Well there's one field called "Special". So in the form I didn't place "Special" as a memo...(It holds notes on the customer, etc.) I would like there to be a button that says special but I can do that. My problem is setting it up to were it will open basically another form display the info that is already in there and let's me add it to that record. Ok Thanks. Sorry for the confusion.

 

[dgm]

If u create a new form bound to your 'SBS' table, with a text box on it bound to your 'Special' field, and say call the new form 'frmSpecial'

Then from your 'Special' button on your main form, do something like this:

sub special_click()
    Dim strCrit as string

    strCrit = "[sbsID] = " & me.sbsID

    DoCmd.OpenForm "frmSpecial", acNormal, , strCrit, , acDialog
end sub

Assuming your table is setup something ilike this:

table SBS
-----------
sbsID
sbsName
sbsPurchDate
sbsSpecial
...

So when u click on the special button, it will pop up a new form where u can view/edit the details in the special field and close it when u are finished...

Not sure if that's what u wanted or not, and hopefully i didn't just confuse u even more

 

[gMAC]

Instead of making a new form, you could place a large textbox over some of your existing controls, then in the Property’s Box under Format select No for Visible. Next create a new command button, in the On Click event place this code for your textbox, Me.YourTextbox.Visible = Not Me.YourTextbox.Visible = True. This will toggle the visible property when you click on your button. Hope this helps.

gMAC