What do you mean by field value? I've placed it after the list box where I select the new value, but no good results. I tried making a subform, but no luck.
It works if I select the value, go into the design view, and when I come back out of the design view it has the new query, but it doesn't refresh while I am on that page.
At this point, I am thinking of leaving that option out of the program for now, and maybe...
WilDel97
Last Activity: Jan 5 '19, 07:40 PM
Joined: Feb 1 '07
Location:
-
I tried changing a few things:
I changed the text format to a number and everything works, except, when I select a project in the list box it passes the right value to the query but the form doesn't update.
I am doing the list box as an unbound list box on the same form.
The form is based on the query I am updating.
If I close the form and re-open it after selecting the value it shows the...Leave a comment:
-
Sorry to bother again, but I got the upate to work like you suggested, but the value I am passing from my list box is a text field with a zero in the front
Value = 072001 (that is the way we assign project numbers)
Year (2 Digits) - Company (1 Digit) - Job Number (3 Digits)
This is something I cannot change, as it is how we track everything in our accounting.
But when it gets into the query,...Leave a comment:
-
Never Mind
Found it in the VBA Editor
SorryLeave a comment:
-
Been working through some other options, but went in to try and set up what you had shown. Having trouble.
When I run it, I get a Compile Error - User Defined Type not Defined.
I guess I didn't understand where the Tols/Reference had to be set
ThanksLeave a comment:
-
Thank You
I appreciate the point in the right direction. I set it up with the WHERE clause, and got it do what I wanted. However, it is running on a continuous form, so it would not requery when I went to a new record.
I thought about leaving a post and asking for more help, but I also need to learn this stuff for myself. So, I dug a little deeper in the forums and found what I needed, some code to run behind the...Leave a comment:
-
Thank You.
I had been working along those lines, but it never worked quite right. But now that I know I am working in the right direction, I can get it figured out.Leave a comment:
-
Limiting Selections for Values in a Form or Table
Hi,
I've been coming to this forum for a couple of weeks looking for a solution to a problem I'm having, and don't know if there is an easy solution. I've worked with Access for a while, but only the basics, and I know very little about VBA, but I am trying to teach myself, so pardon me if this makes little sense.
I am writing a truck dispatch program, and I am trying to limit selections in a table/form based on earlier...
No activity results to display
Leave a comment: