Recent content by ALF3911

Thanks for the help. I never did get it to work, but I managed to work around it.

Ok, that gives me the same error. I did not mention before that the subform lies in a tab control on the main form (I did not think it was important). I am beginning to think that might make a difference. Do I need to call the tab control page first? If so, how can I do this? Thanks

I am slowly learning VBA code on my own and really like it. Unfortunately, I sometimes get stuck on things that I think are easy. I am trying to access a field from an open subform and copy it to the form that just loaded. I am trying the following: Private Sub Form_Load() TechID =...

I think I understand what you want to do. The easiest way I know to do this is as follows: In the combo box properties, click on the ... box and build a query to handle the combo box based on your table. Insert the field you are listing and sort is ascending or decending based on your needs.

Thanks for the help. [This message has been edited by ALF3911 (edited 06-05-2001).]

I have a form that defaults to todays date as a received. I need the form then to calculate a date 5 business days later as a due date. I can make it auto-fill a date 5 days in the future, but cannot make it skip the weekends. Thanks.

I generally solve this problem by creating a data table that will equate K-1 to K, 1, and K-1. Then I join this table in my search query.