By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,282 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

Check Values Before Insertion

100+
P: 194
Hi Experts Around the World. I made a table called mainTable, two fields of this table one is SNO and other is Relation are text data types. SNO and Relation can be any string values. Relation stores value from a combo fox on form called mainForm, this form is based on mainTable. Relation values can be "Self", "Wife", "Son", "Daughter", "Mother", "Father", which can be selected from combo box. I made a query qryMainTable based on mainTable, this query returns SNO and Relation values if Date value = Is Null.

Now i made a form in design view called frmCheck. I took two unbound text boxes one is SNO and other is Relation with a command button. On click this command button, the values in text boxes should check values in qryMainTable. If frmCheck's SNO found in qryMainTable's SNO and Relation of frmCheck= "Self", then a message displays "Entry Exist" and the text boxes should be cleared. If frmCheck's SNO found in qryMainTable's SNO and Relation of frmCheck= other than "Self", then a frmMainForm Should open with SNO and Relation values as entered in unbound text boxes of frmCheck and these values should be stored in table mainTable.

All my project based on test values before insertion. This will really give me a breakthrough if i got this solution. I will be grateful if a help is provided to me at this problem. Thanking all of you.

Mohammad Faisal
Oct 9 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
Please don't post the same problem multiple times. It will cofuse our experts and it's harder for you to keep the responses "lined up".

I'm closing this thread and ask the other experts running into this thread to join in at:
http://www.thescripts.com/forum/thread720030.html

Nic;o)
Oct 9 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.