Solved

Update a table

Posted on 2011-03-16
2
197 Views
Last Modified: 2012-05-11
Experts,

I have a form frmLetterOfCredit_Cont that is built off of tblLetterOfCredit.
I also have a form frmLetterOfCreditAdd built off of tblLetterOfCredit.
What I need to do is update [region] that is contained on frmLetterOfCreditAdd without having to actually go to this form.  
[Region] is a combo box.

While on frmLetterOfCredit_Cont I enter in the "Country" from cboCountry on this frmLetterOfCredit_Cont and after I update this I want to be able to update this field named cboRegion [Region] on frmLetterOfCreditAdd

both forms are built off of tblLetterOfCredit.  

The reason I want to update cboRegion instead of actually going to the form is becuase the network is a little slow and I do not want to transfer this field to frmLetterOfCredit_Cont but let it remain on frmLetterOfCreditAdd.  

cboRegion on frmLetterOfCreditAdd rowsource:
SELECT tblRegion.ID, tblRegion.Region FROM tblRegion ORDER BY tblRegion.Region;

I guess I would need an unbound form with cboRegion on it and then once I select one of the options from the dropdown box then the [Region] field on tblLetterOfCredit would update with what I selected from this unbound field on a form called say frmRegionPopUp.

Maybe there is a much simpler way to do this.  I am open to suggestions of how I could update the value on the combo [Region]  under tblLetterOfCredit while on frmLetterOfCredit_Cont without having to actually go to that frmLetterOfCreditAdd where [Region] resides.  Keep in mind that the both forms contain tblLetterOfCredit and I could get a WriteConflict error.  

LetterOfCreditID is the link between the forms frmLetterOfCredit_Cont and frmLetterOfCreditAdd.

thank you.  Please ask questions if not clear.

I attempted to do this myself with an AfterUpdate on cboCountry but did encounter a write conflict error (but now I believe an UNBOUND form would be better than a bound form which is what the frmRegionPopUp was built off of (tblLetterOfCredit).

Private Sub cboCountry_AfterUpdate()

     If IsNull(Me.cboRegion) Then
        MsgBox "Enter the Region of Export on the LC Detail form (click LC No)", vbInformation
    '    DoCmd.OpenForm "frmRegionPopUp", , , "[LetterOfCreditID]=" & Me.ID, , acDialog
    'Me.Refresh ' have an issue with write conflict...removed docmd. 3/15/11 have tried refresh, requery, dirty...posted EE.
   
    End If
   
End Sub



Hope it makes sense.  Let me know if you have any ideas.  

0
Comment
Question by:pdvsa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Author Comment

by:pdvsa
ID: 35147607
There are a lot of words there.  Just a summary:  I want to update tblLetterOfCredit [Region] without having to go to the frmLetterOfCreditAdd.  I want to do this while on frmLetterOfcredit_Cont.  

I guess I could drag [Region] on the frmLetterOfCredit_Cont and hide it then make it visible but it would look a little funny becaus I have no space for [Region] on frmLetterOfCredit_Cont.
0
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 35154233
If control is not visible, you can put it behind any other control. It will be not easy to edit (you can use Tab to move between controls).
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question