Search results

That is correct, the main form and sub form are linked by QUOTE_ID, so I guess no way around the behavior...

I have a form with a sub form, and if the sub form has multiple line items, I have to click the next record or previous record buttons as many times as there are line items in the sub form, in order to move to the previous or next master record (Quote ID). In the enclosed screen shot, I have...

Does anyone know code to snap a form to the very top right corner of the main window? I know how to do it for the top left. I also know how to make the top right happen in inches, but each of my 8 forms are a different width, and not all users have the same screen resolution. Is there an easy...

That did it, thanks!

It is still bound to the underlying query.

Hi, I use this code on combo boxes on many different forms, but on this particular form, I keep getting 'Run-time error 13' on "Me.WIDTH = Me.PRODUCT_ID_COMBO.Column(4)" if the column has no data, and also, if it does have data, it will not insert it into the form like all the others do. The...

Thank you. I tried this and still not updating...?

Also I'm not sure what you mean by 'concatenate the Me.PROD_SUB value as you did with Me.QUOTE_ID' Thanks for your time.

You are correct, I simply want to store the calculated values on the sub forms into their respective tables after the fields are updated. I don't know how else I could do it without using code. Thank you.

Hi, I have a main form with 3 sub forms. The main form is tied to a table called QUOTES_MASTER. The first sub form is tied to a table called QUOTE_LINE_ITEMS_DIRTGLUE. It calculates the subtotal when selecting items. The relationship is one-to-many linked on QUOTE_ID. The second sub form...

Hi Bob, here is another screen shot with more details.

Hi Bob, just now saw your last message. It won't let me save as 2003, says it has features not available in 2003. Anyhow, it is a front end, so I would have to send you the back end as well.

It is a built-in macro the wizard made: SelectObject Form, QUOTES_DIRTGLUE, No GoToRecord Form, QUOTES_DIRTGLUE, Next, The weird thing is it works properly if I recreate the buttons, but after saving and closing, after reopening the form it starts scrolling through the subform again.

Not quite what I'm trying to say. If there is more than one record in the subform, access goes to each of the next records in the subform, and that isn't what I want. I want to go to the next parent record without scrolling through each record in the subform. See the attached form image. I want...

Thanks for the reply. The built-in navigation buttons on the bottom of the main form are visible, but the subform is a data view only, how it needs to be. Whether I use the built-in navigation buttons, or buttons made by the wizard, either way it scrolls through all the child records before...

I have a parent form tied to one table, and a subform in it that is tied to another table. The relationship is one-to-many, and if there is more than one record in the subform, when clicking next or previous, it scrolls through the subform items. I would like the Previous and Next buttons to...