I've been struggling with a form. On the left side of the form I've got data from a table of invoices, and on the right side I've got a combo box with data from a table of payments. The user scrolls through the invoices on the left and matches each one up with a payment from the combo box on the right. The common field is an order number, but the relationship between invoices and payments must be created manually by the user matching up the records.
I have two problems:I can't seem to get the requery or refresh working properly - each time the user scrolls to a different invoice on the right, I need the combo box on the left to refresh so that it will only return the payments that correspond to that order number.
My second problem is that whenever the invoice and payment are matched up and the record is saved, the form jumps back to the very first record. I need it to move forward to the NEXT record so that the user doesn't have to keep going back through previously viewed invoices.
I'd really appreciate any help.
Thank you!
6 5329
I've been struggling with a form. On the left side of the form I've got data from a table of invoices, and on the right side I've got a combo box with data from a table of payments. The user scrolls through the invoices on the left and matches each one up with a payment from the combo box on the right. The common field is an order number, but the relationship between invoices and payments must be created manually by the user matching up the records.
I have two problems:I can't seem to get the requery or refresh working properly - each time the user scrolls to a different invoice on the right, I need the combo box on the left to refresh so that it will only return the payments that correspond to that order number.
My second problem is that whenever the invoice and payment are matched up and the record is saved, the form jumps back to the very first record. I need it to move forward to the NEXT record so that the user doesn't have to keep going back through previously viewed invoices.
I'd really appreciate any help.
Thank you!
Look at the BOOKMARK property in Access, the general sequence being ....prior to 'saving' set a pointer to the bookmark...save and then return to current record to the bookmark .Plenty of references for this in help
Regards
Jim
I didn't know bookmark was the term - thank you. I'll research that in help.
Do you have any advice for my refresh/requery issue?
I didn't know bookmark was the term - thank you. I'll research that in help.
Do you have any advice for my refresh/requery issue?
Refreshing a combo box based on the value of another combo is very common Access stuff in the afterupdate property setting of the box on the right you should be setting the row source for the combo on the left to requery itself and return records that relate specifically to the bound value selected in the right box with something like Me!LeftComboNam e.requery.
The fact that your users have to manually insert the link key is somewhat perturbing because in the design process you ought to be keeping that mechanism out of reach of users and let access do it behind the scenes?
Invoices ,orders and payment systems are quite common Microsofts Northwind traders database example gives example of how link keys should behave ie no human interaction
Jim
The reason the user has to manually create the relationship between the order and the invoice is because the data is coming from two different systems and there isn't a reliable way to programmaticall y create the relationship. The invoice amounts are auto-billed to credit cards so an invoice is automatically created (by an outside vendor), and in our in-house system we determine whether the standard charge is the only one that will apply for that month, or whether we need to bill the client for an additional amount. Therefore we have multiple payments for each order.
The reason the user has to manually create the relationship between the order and the invoice is because the data is coming from two different systems and there isn't a reliable way to programmaticall y create the relationship. The invoice amounts are auto-billed to credit cards so an invoice is automatically created (by an outside vendor), and in our in-house system we determine whether the standard charge is the only one that will apply for that month, or whether we need to bill the client for an additional amount. Therefore we have multiple payments for each order.
okey cokey that explains it much better I mistakenly took it to be all done it Access I apologise unreservedly if I appeared to be overly critical
Jim
No need to apologize - I'm not that good at Access, but I'm not completely hopeless. :-) I really appreciate your help and advice - everything is working perfectly now.
Thanks very much!
Donna
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: John Baker |
last post by:
HI again:
I have made 2 posts on this issue, and for some reason still haven't got the right result.
I have a form which contains a number of totals. These totals use unbound control boxes
and are of the form: =Dcount("field","table"). The form contains a number of buttons which
trigger queries (using a macro) that update some tables and delete records from others.
The effect of these macros is to change the counts that should register...
|
by: Dave Boyd |
last post by:
Hi,
I have two very similar forms each with a subform. The main form gets
a few fields from the user and passes this back to a query that the
subform is bound to. The requery is done when the user enters the
last qualifying field on the main form.
In one case this works fine, the subform shows the data the user wants
to update -- which means showing all the data put in previously (ie
showing this via the requery and the continuous...
|
by: Andrew Chanter |
last post by:
I have a situation where I am using an unbound dialog form to update data in
an Access 2002 split back end / front end scenario. The data update is done
via an ADO call (direct to the back end db) when the user clicks the save
button. The dialog then closes and the user should be able to see the
result of their edit in a list view that now has focus. This is where I run
into a problem. The list view wont refresh to pick up the data...
|
by: Henry Stockbridge |
last post by:
Hi,
I have a popup that is used to update the records on an open form. I
cannot get form to refresh with the new values. Any help you can lend
would be appreciated. Here is the code for the popup form:
'-----------------------------------------------
Sub AddRep_Click()
Dim db As Database
|
by: scott |
last post by:
I guess this is a simple one but I can't seem to get it to work. I want to
refresh an open form "onClose" of another.
I have a Close button on a form which has User Details on it. If I update
the data on that from, I want it to automatically refresh the details which
are shown on an open form.
I was going to use the default access code
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
| |
by: Birderman |
last post by:
HI,
Any help would be appreciated.
Using Access 2003
I Have a form with several buttons to drive different events that work.
I want the buttons to be enabled or disabled dependent upon certain entries
within fields on the form.
|
by: Chris Larmer |
last post by:
I have two subforms in my main form.
In the main form I want the user to select a customer, class, and date range.
The 2 subforms are similar. One is the history records in the recent past and the other is future records. The user has to input a passenger forecast for the customer for the selected class for each record in the date range.
The subforms are populated by a query which is altered according to their selection.
I wish to...
|
by: mattcolenutt |
last post by:
Scenario: Have a product form with an "image location" field. The
image property uses this field to display the image.
Problem: If an image location field has been changed, the image will
not refresh, even after putting a "refresh", or "repaint" or "requery"
statement in the afterupdate event. The only way to make it update is
to move to the next record and then move back again.
Private Sub Stock_ImageLocation_AfterUpdate()
|
by: aaronyoung |
last post by:
I have created custom navigation buttons and Record Number indicators on several forms that are used to review and update records based on a query.
My On Current event to update the "Record X of Y" is
Private Sub Form_Current()
Dim frm As Form, LastRec As Long
Set frm = Forms!ReviewSearchRecordsForm
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |