Select, Update and Add problem, still looking

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

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

Attachments

Please test your sample mdb before attaching. There seems to be an error regarding a macro that is missing "tblIssues"

David
 
Try this new attach file i am sure this will be ok.
 

Attachments

I am still looking for a solution, Could anyone can help me on the above attached program.
 

Users who are viewing this thread

Back
Top Bottom