General information
Category:
Forms & Form designer
>I checked the things you suggested. I much appreciate the idea of "Select ViewName" on the click or GotFocus - never occurred to me the buttons >would lose thier way.
> I have it working now, I think my problem was that I was skimping on TextBox ControlSource. In switching from the Table (CampUnit.dbf) to the Local >View (CampUniv), I ended up with ControlSource values like- Facilityno when I changed them to CampUniv.Facilityno things started working again.
> Thank you. Your details keep me from straying.
> Sylvia
There are so many details when you cange the data source for a form (who said OOP was so easy, lol) that you can miss something soooo easely.
I am glad you were able to work this out. Now, next time you do a form, you can base it on a view and then if you need to add fields or even other linked tables you won't have to re-do everything again (ViewName.FieldName stays the same on existing fields). I do this even if I only want one table with no filtering for the form, just in case. BTW if you use the View Wizzard it will do the SQL for you (oh how I love to cheat on these things) and 99% of the time it will be right, when it's not, the results will tell you so, and then you can write the string yourself.
Oh just another little trick, the PageFrames have a bug... oh I mean undocumented feature, they do not always refresh when you view new pages on the same record. I always write "This.Refresh" in the click event of the pageframe, just remember to also add "DoDefault()" on the next line so you still run the code from the wizzard.
John
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only