Search results for query: *

I don't think you can do what you want. I believe you will need the full retail version of Acrobat to create and edit forms. As far as I know Acrobat doesn't have a layer that would permit interface with Microsoft products. ASMELS

Try creating a new DB in A2007 and them importing the objects from the A2000 DB. That may be a better way than letting Microsoft decide how to do it.

Thanks Lisa: Unfortunately your suggestions won't work. Item (1): The main form doesn't need a record source as it's unbound. The combo box control on the form must have the union query as its record source so that outdated names will appear on the selection list. Binding the form to the...

Thanks for the suggestion Ace, but no joy here either. ASMELS

Hello PHV: The main form is unbound and has a record source of: SELECT DISTINCTROW qCustomerName.CustomerID AS Expr1, qCustomerName.Name1 AS Expr2, qCustomerName.City AS Expr3, qCustomerName.State AS Expr4 FROM qCustomerName ORDER BY qCustomerName.Name1; The query upon which the recordsource...

Hi Lisa: Thanks for looking in and taking the time to address my issue. Both forms are unbound so you can't build a link between them. The SetFocus and Requery statements are holdovers from A97 which required them. Perhaps I should bind the forms and see if that help. Thanks, ASMELS

This routine works fine in A97, but 2007 doesn't like it. I have a form (AddressMgr) that has a datasheet subform (AddressSubform) that displays customer address data depending on address element selected in option group (PickGroup) on form. Technique is to build SQL record source and pass it...