Creating message box

[satrio evan]

Good morning,
I'm new in access and i have a question about creating message box, before that i explain mydata first.
I have table says TablePart which contain fields :
ID ( auto number) and Part (text) : PartA, PartB,PartC and PartD
from this table i create form named FrmTablePart
I have another table says TableData which contain fields :
Date , Partname ( combobox type, record source from Part in TablePart) and Quantity
from this table i create form named FrmTableData.
When users open FrmTableData and they write in Partname field "PartE". Because "PartE" is not in list of TablePart , i want message box display a warning message for example " This Part Not in List, do you want to input this one?" if they click Yes then it will open FrmTablePart (Record gotonew) and if they clikc No then cancel write this "PartE"
Is this possible to create it??
Thank You

[pod]

yes it is possible

This is just a wire frame of what could be done

Query_IsPartE-In-TablePart = "select * from TablePart WHERE Part = [Partname field]"
execute Query_IsPartE-In-TablePart
if your Query_IsPartE-In-TablePart does not returns results
  wantToInsertText = "do you want to insert it into table?"
  if msgbox(wantToInsertText,...) = vbYes
    execute NonQuery_insert_PartE-In-TablePart
  end if
end if
 

[NeoPa]

I'm not about to do it all for you, but the answer is "Yes". It can be done.

There are even questions related to that here that may help to get you started with your design.

MS Access not in list event
Go to specific field in form using "on not in list " in access