Recent content by BillH

Hi Rich, I finally had some time to get back to this and re-evaluate exactly what I'm trying to do here (from your obvious points - which made complete sense). Not sure why I built it this way initially. Anyways, I included those fields into the same table and then figured out how to auto-fill...

Hi Rich, The ClientInfo table looks like this: ClientNumber ClientName Insureds Premium 101 Smithson 235 $48,000 102 IBM 12000 $102,000 103 ATK 190 $22,000 There are...

Thanks Rich and Pat. Rich - The form is basically a data-entry form. Each record (or qualification) would only contain a single qualification for a single client. So, I guess it is a one-to-one relationship but I am using 2 separate tables. "Qualification" is for the data-entry and...

Hi Rich, There would only be a single client per qualification (one client to a qualification). I think (although I'll have to go back and check) I built this as a subform because the data that is auto-populated is based off of a query. Could I accomplish this without using a subform...

I'll do my best to clearly describe this - any help would be GREATLY appreciated! 2 tables: Qualification and ClientInfo. 2 forms: Qualifier (main form - from Qualification) and QualifierSub (subform - from ClientInfo) Qualifier contains fields to enter general info about a particular client...

Set appointments for others??? Hi Georget, This is very cool! I've been trying to figure out something like this for a while. My question is if the code can be modified to create appointments for yourself and for co-workers. Any thoughts? Thanks again

No luck. Thanks anyways

Thanks David. I grabbed the following code from the help area: Private Sub Form_Current() Dim strCond As String strCond = "BrokerID = Forms!BrokerList!BrokerID" ' Use the IsLoaded function from the Northwind ' sample database to check whether the Products ' form is open, then set the properties...

Okay - I think I've seen similar problems on the board and I've tried a few suggestions but no luck so far. I have 2 subforms on the same form. The 1st subform, "Broker Listing" is in datasheet view with multiple broker names. The 2nd subform is "Broker Details" which is in form view and...