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

Check Values Before Insertion

100+
P: 194
Hi Experts Around the World.

Well im new to this paradise (Access). i have no experties in Access but i can still work with my mind :).

i wish to request you people as under:

I made a table called mainTable, two fields of this table one is SNO and other is Relation are text data types. SNO can be any string values but relation stores value from a combo fox on form called mainForm based on mainTable. Relation values can be "Self", "Wife", "Son", "Daughter", "Mother", "Father". 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 entered in table mainTable.

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 confuse 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.