I've got a couple of items that I've been stuck on for several hours. If there is anyone that can help, I can email the database to you to take a look at. It about 1 1/2 megabytes in size.
Here is the statement from the row source properties that I'm having a problem with:
SELECT [Trucks Under Brokers].[Truck Number], [Trucks Under Brokers].[Broker Number] FROM [Trucks Under Brokers] WHERE ((([Trucks Under Brokers]![Broker Number])=[Ticket Table]![Broker Number]));
Under forms, the Ticket Table sub is my main form. The 2nd field within the form is the broker field, which works great. If you select broker 1 in this field, and then move down to the Truck number field, you will see the trucks that are listed for broker number 1 (this comes from the trucks under broker form). This will only work once, when the form is first opened. If I go back up to the broker field, and change the broker number to 8, and then come back down to the truck number field, it will still display trucks from broker 1. The only way it will update is, if I have data in all the fields, and click on records, then refresh on the pull down menu from above, or if I close the form and open it back up again. It only looks once. If I just save the record and start to add a new one it will only allow me to use the truck numbers from the broker I entered on the first entry screen.
In the trucks number field I have a combo box, and on the row select of the properties I have a statement telling it to get the broker number from the broker number field. I think something needs changed.
My 2nd item that I'm stuck on is after I have run a report (I have 4 that basically run the same way, they are Cramblett invoice to clients, ticket table, ticket table jnc logistics, and jnc invoice to clients.) These are all based on queries. On the ticket table report, they enter a broker number, a beginning date and an ending date range. This pulls all the info from that broker number within the beginning and ending date range. Works great. What I need is to be able to then is to have the ability to mark those as paid so that if a week later something comes in from the same broker, from the same time period, and they run the same report, it does not pull up the previous data and add it to the new data, thus invoicing them a 2nd time for the same thing.
I was thinking that maybe a query of some type could be used to add something like a check mark or a Y to a field during a query to somehow mark the data by broker within a beginning and ending date range as paid. Then somehow a small modification by made to my existing report based queries to somehow skip this data during a report if there is a checkmark or a Y in this field.
I can't thank you enough for your help. I'm in kind of a bind here and really need help.
Thanks,
Jim
Here is the statement from the row source properties that I'm having a problem with:
SELECT [Trucks Under Brokers].[Truck Number], [Trucks Under Brokers].[Broker Number] FROM [Trucks Under Brokers] WHERE ((([Trucks Under Brokers]![Broker Number])=[Ticket Table]![Broker Number]));
Under forms, the Ticket Table sub is my main form. The 2nd field within the form is the broker field, which works great. If you select broker 1 in this field, and then move down to the Truck number field, you will see the trucks that are listed for broker number 1 (this comes from the trucks under broker form). This will only work once, when the form is first opened. If I go back up to the broker field, and change the broker number to 8, and then come back down to the truck number field, it will still display trucks from broker 1. The only way it will update is, if I have data in all the fields, and click on records, then refresh on the pull down menu from above, or if I close the form and open it back up again. It only looks once. If I just save the record and start to add a new one it will only allow me to use the truck numbers from the broker I entered on the first entry screen.
In the trucks number field I have a combo box, and on the row select of the properties I have a statement telling it to get the broker number from the broker number field. I think something needs changed.
My 2nd item that I'm stuck on is after I have run a report (I have 4 that basically run the same way, they are Cramblett invoice to clients, ticket table, ticket table jnc logistics, and jnc invoice to clients.) These are all based on queries. On the ticket table report, they enter a broker number, a beginning date and an ending date range. This pulls all the info from that broker number within the beginning and ending date range. Works great. What I need is to be able to then is to have the ability to mark those as paid so that if a week later something comes in from the same broker, from the same time period, and they run the same report, it does not pull up the previous data and add it to the new data, thus invoicing them a 2nd time for the same thing.
I was thinking that maybe a query of some type could be used to add something like a check mark or a Y to a field during a query to somehow mark the data by broker within a beginning and ending date range as paid. Then somehow a small modification by made to my existing report based queries to somehow skip this data during a report if there is a checkmark or a Y in this field.
I can't thank you enough for your help. I'm in kind of a bind here and really need help.
Thanks,
Jim
