I would like to have message box with three options every time I select a form.
The three optios are
1-add new record (I am ok on this)
2-edit a record (Need help please....)
3-cancel (Help please..)

When 2 selected, I would like the system to prompt and get the record key field number from user. Then form can open with the requested record.

I hope this is digestable.

Can anyone help me on this?

Many adavnce thanks

sinnah

I think you're going to have to create a little form that looks like a message box, (set Modal and Popup properties to True) and put the buttons that you want on that.

Mike

After you make your form as Mike mentioned, if the second option is selected, you can use an input box to accept the key field from the user in VBA. Syntax would be:

Dim strInput as String

strInput = Inputbox("Please enter number")

Then use the string variable to assign the value to the correct field.

Thanks Mike & DML

How can i use the variable string to goto specific record that user specifys to edit.

Sorry I am not an expert on vb.

many thanks again

sinnah

After the string input yopu could use a search function like

Dim strInput as String
dim sfind as string

strInput = Inputbox("Please enter number")
sfind = "FIELD like '*" & strInput & "*'"

this should assign sfing to the appropriate record, then just dispaly it

Thank you Cwillam, now I can understand it.

sinnah