I have a continuous form setup that the user enters a registration number, in the after update event I look up the register persons name and place it into an unbound field. My problem is when the second row puts up the name from the first record show up in the unbound field. I know why it's doing this but is there a way to have the name not show up until the registration number (a different one of course) is entered into the second record.
Thanks again for all your help.
8 4757
Tom,
This has to do with the continuous forms. Perhaps, use a single form that cycles through individual records?
Ok, now I'm going to sound dumb, on a single form how do you cycle through individual records, and make it look like a continuous form?
Not a dumb question at all. You cannot use a single form to make it look like a continuous form.
Perhaps you could show us the form and the code behind it. Help us to understand what you are trying to do. It is a bit strange to have an unbound control on a continuous form, as once you change that control, it will be changed for every record.
If your user is pulling up the registration for one person, then I'm not sure you need a continuous form--single form should serve your purpose; just filter by the selected registration number.
OK, I understand what's happening and that's what I'm trying to do away with. This is and transaction input form and the user will be entering maybe 15 or 50 transactions a day. When he/she enters the registration number they want to see the customer associated with that registration number to verify it's the correct person, that name comes from the customer table. There is also another field they want to show which comes from another table. The data from the input form will go into the transaction table which will contain only the registration and customer number and of course other transaction information. And as you say for each transaction when the user enters the registration number the lookup information shows on the next record. I've tried a couple of different ways to lookup the data. In the unbound field I've done a Dlookup to find the customers name and also the registered boat's name, I've also entered information in the AfterUpdate event of the registration number but just get the same result.
I hope this makes some kind of sense.
Thanks again for your help.
Tom,
It does make sense. Let me throw this concept off you to see if I understand what you are trying to do:
A User enters a Registration number
The Form pulls up the Customer associated with that registration number
Other "Data" from another "Table" is also displayed
The User then adds data to a Transaction Form capturing data associated with this Customer/Registration Number
Is this correct?
First, I would need a snap shot of your relationships--particularly as it releates to the Customers Table, Registration Number, the Transanctions and this "Other Table" (please grab a screen shot and attach to a Word Doc, as this will display better as resolution is limited on images. Please also include in your response the data types of your key fields (you could do a screen shot of each table in Design view).
My thought is that what you are trying to do is very easy by using a subform, with the established relationships between tables, such that the User just Enters a Reg Number, selects/verifies the Customer and click "Add Transaction" and the subform is now available, and because of the relationships, would add a record related to that customer/Reg Number.
We may also have to talk about database normalization....
Why do you have it unbound? You should have a transaction table that is related to both the customer table and the "other table" you mention. You then create a query that includes the fields from the transaction table and the fields needed from the two related tables. When you enter a registration number, the joins make the data pop appear automatically without any code.
For example, using the Northwind sample database (if you haven't already, you should download it), run the following query (I'm using the 2007 Northwind version which works for Access 2007, 2010 and I think 2013 as well): - SELECT [Order Details].ID
-
, [Order Details].[Order ID]
-
, [Order Details].[Product ID]
-
, Products.[Product Name]
-
FROM Products INNER JOIN [Order Details]
-
ON Products.ID = [Order Details].[Product ID];
-
Scroll down to where you see the new record. The product field will be a combobox. Select a product and you will see the product name appear in the Product Name field. This obviously is redundant to the name that shows in the Product field's combo box, but it demonstrates what you can do for your system.
I'll see about the screen shots, right now I've got to run and will not get back to this until tomorrow. Thanks for the suggestions and I'll continue this project later.
Thanks again.
I just got back to the form problem and have figured a way to make this work. What I did was in the unbound field that looked up the customer info I put an iif statement, so if the look up field was blank (meaning no registration number has been entered yet) if this is true then I just put " " (blank) and if there was a registration number present the I did the dlookup for the customer name. It worked great and the new line on the continuous form doesn't show the previous user information.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Prakash Wadhwani |
last post by:
Is there any EASY way to highlight a full row in a continuous form so
that as i navigate up & down the table/continuous form using the arrow
keys, the entire line (all fields) get highlighted ?
...
|
by: Pat |
last post by:
Hello,
I've used Sum() to total bound fields on a continuous form with no problem.
However, I now have a continuous form, on which I use an unbound field to
calculate the number of hours between...
|
by: Roger |
last post by:
I've got a continuous form based on a query
the first 2 controls on the form are bound to columns in the query
a third control (paymentAmount) is unbound
I have a total control in the footer,...
|
by: Kathy |
last post by:
What is the standard technique for handling the fields in the following
scenario on a continuous form?
Multiple Divisions. Each Division has multiple Buildings. Each Building has
a Supervisor.
...
|
by: DFS |
last post by:
I'm sure this has been discussed before, but I'm too tired to hunt for it.
I have a survey table containing questions with different answer scales.
Some are 1 to 5, others are A,B,C, etc. I show...
|
by: Robert |
last post by:
Need some help to stop me going around in circles on this one....
Have a nested subform (subform2) which simulates a continuous form for the
record on the parent subform.
Subform2 has rows of...
|
by: Welie |
last post by:
I am having a problem an it's driving me crazy, I hope someone can
correct my technique. I can't find a pattern and don't know where to
look to debug this. The problem is on a continuous form, the...
|
by: eighthman11 |
last post by:
using Access 2003 and sql server version 8.0
Hey everyone. Created a text box where the user types in an Inventory
number and it takes them to that inventory number on the contimuous
form. The...
|
by: kcdoell |
last post by:
Hello:
I three fields on a continuous form:
, &
On the same form I have an unbound text box with the following formula in the control source:
=Sum(IIf(=50,,0))
This worked great.
|
by: pat088 |
last post by:
I have a group of unbound fields which are added together in field v15 in a continuous form. I want a bound field to equal v15 so it can update a table. How can this be done? I tried using the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
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,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |