![]() I've created two Listboxes for this page. It's the second Page of the Tab control where I'm having issues. The first page of the Tab Conrol contains other fields from the Clients table for the current Record. ![]() In the Form's Header I display the Client Name and Phone number for the record being viewed. Each client can own multiple Properties, each property can have multiple associated Contracts. I have three primary tables to define my relationships. Perhaps I've been going about things in a fundamentally wrong manner? Here's what I'm trying to accomplish.as a newbie to Access I'm most interested in any recommendations as to how to achieve my task. However, I'm finding that this event does not fire off when the Value of a Field changes via VBA code it only seems to fire off through user interaction via the GUI. ![]() TextBox) on the Userform to trigger changes in related fields.Īlthough the Access Help file refers to a Change Event, it doesn't appear it really exists in the context I'm attempting to use it, thus I've resorted to the AfterUpdate event. Often, I take advantage of the _Change Event, for a Field(eg. In Excel, I make extensive use of UserForms that I manipulate with VBA. ![]() I'm hitting a wall though on manipulating Access Forms. Given the nature of my data, a relational DB is where I need to be as opposed to the way I've prototyped things with Excel. I'm attemtpting to convert an application I developed in Excel in order to capture the power Access provides. Hi! I'm new to this forum, and new to Access.
0 Comments
Leave a Reply. |