furnitureheaven
Registered User.
- Local time
- Today, 14:42
- Joined
- Aug 5, 2008
- Messages
- 36
Hi
This is my 2nd post on the same issue, but I haven’t solved it yet.
I have 2 tables LegFile and LegLook related to form LegFile. I am trying to select a RefNo from LegLook table against a Combo Box Selection and after selecting a Refno I want to Update LegLook.RefNo with (add) 1. Steps are following
I have tried many things but can’t overcome /solve the problem. I have attached a db with this post and looking for a solution.
Thanks.
This is my 2nd post on the same issue, but I haven’t solved it yet.
I have 2 tables LegFile and LegLook related to form LegFile. I am trying to select a RefNo from LegLook table against a Combo Box Selection and after selecting a Refno I want to Update LegLook.RefNo with (add) 1. Steps are following
- User first Select “File Type” from Combo box on the form and jumb to RefNo on Form (LegFile).
- On the lost focus of Combo Box, FRefNo will appear on a Refno on Form, and update LegLook Table (previous FRefno + 1).
- When user fill the Fname on form and Click on Add Button. It will add all three values into Table LegFile.
I have tried many things but can’t overcome /solve the problem. I have attached a db with this post and looking for a solution.
Thanks.