Search results

I have an unbound textbox and a subform on a form. The subform is attached to a table that contains a field that holds charge amounts. When the main form is displayed the subform will display all charges that are associated with the main record. Below the subform I have a "Total" in a textbox...

That works. Thanks!

That works great. I need to combine 2 fields, shippers name and shippers address, but when I do I need to have a line feed after the shippers name so that the address starts below the name. How so I do that? Thanks for your help.

I have a form that has a combo box called Shipper. There are 3 columns in the combo box, ShipperID, ShipperName, ShipperAddress. When a user selects an item in the dropdown then there is a textbox below that gets the address filled in from on the combo box. I have created a report based on...

I have one more question since you have a copy of the db. On the report you will notice that where ever there is dropdown on the form the report only prints the id of the item selected in the combo box. How do I get it to fill into the report the item from the combo box as well as the info...

I think that I have it working now. Thank you very much for your help.

However, when I print the report I get both pages, 005 and 006. I only want to print the current page.

Here is the database.

How do I do that?

ID is an AutoNumber and yes the record is saved.

Thanks for your response. I tried what you suggested but it did not work. Private Sub cmdPrintBillOfLading_Click() DoCmd.OpenReport "rptBillOfLading", acPreview, , "[ID]=" & Me!ID End Sub ID is the field in the table and Me!ID is from the form. The ID from the form is passed ok but I...

I have been given the task of creating an application that will print invoices for a client. They want to be able to enter in the info, save it, and then print just that invoice. I have created the input screen and the invoice report. However, when I try to print the report I get a printout...

Duh! I could not see it to save my life. Thanks, I got it to work. Don't go anywhere, I may have more questions later. Thanks again.

Thanks. I have tried many versions of that but none seem to compile. call me.cboShipper_AfterUpdate me.cboShipper_AfterUpdate cboShipper_AfterUpdate call cboShipper_AfterUpdate I am really sorry about being so dense.

Stupid question, what is the code for doing that? Private Sub Form_Current() Me.cboShipper.AfterUpdate End Sub

I am using Access 2007. I have a form that has a dropdown and an unbound textbox on it. I have created the code in the On_Change event to that when I select an item from the dropdown the textbox is populated with data from one of the dropdown columns. Here is how I have it arranged...

Sorry, I am using 2007, windows XP Pro. I put a msgbox in the code and it did not execute. Yes, the address is the third column. I do see the [Event Procedure] next to the AfterUpdate. Thanks for your response. I am not finding anything on this.

I have put a break point in the code and it never reaches it. That is why I did not put the code in. Private Sub cboConsignee_AfterUpdate() Me.txtConsigneeAddress.Value = Me.cboConsignee.Column(2) End Sub

I have a combo box that has code behind the AfterUpdate event. When I run the form nothing happens. What am I doing wrong? Thanks.

That was perfect. Thanks!