Search results

I know I'm probably responding to this too late, but I hope possibly Rich might still read this. In response to your question, I can't use a calculated control because I'm trying to pass this value in the "Total" text box on to a report and it is my understanding that the only way to do this is...

I'm still a little unclear. I'm trying to put this in a global module so the value can be used in a report. Because it is a calculated field it does not have a control source from a table so it has to be placed in a module right? Can these be currency fields in my table instead of number...

I'm trying to create a standard module with a public function. The function is a simple calculation that returns a value to a text box called "Total". I'm having a hard time creating the module. The function is...

Thank You for your response. I'm a little unclear as to how to write a public function. I've only really done private functions and attached them to events. In a public function do I still attach it to an event. It seems like you would have to but how would the report pick up the value. If...

Is there any way you can have a value from a calculated text box on a form appear on a report without having that form open? I am trying to generate a report. The report is derived from a number of tables so I put together a query. One of the forms frmCharges has multiple text boxes and combo...

Here's what I did. The combo box created has to have a control source to be bound to the form. You have to create an entry in your table where the combo box is located to link them. To illustrate my example: the combo box looked up a shipper name. There were three fields in my box: Shipper...

NO NEED TO ANSWER FIGURED OUT MYSELF

My question is how can you make a combo box based on a Table/Query on a form change with the different records on that form? I created a combo box that looks up information (shipper) on a query. This combo box contains three fields (Shipper)(ShipperID) and (ShipperAddress). When you input a...