Totally confused with this one

poporacer

Registered User.
Local time
Today, 00:34
Joined
Aug 30, 2007
Messages
136
Lets see if I can make this clear. I have 2 tables, one table (tblContacts) has information on contacts....Name, address,Phone, etc. the other table has information on meetings (tblMeetings). This table has information to the meetings...date, time, name(from tblcontacts), objectives, issues, etc. For each meeting, I will have several entries for the same meeting (one for each client present). the reason to have a separate entry for each client per meeting is that each meeting will have different clients and each client will have different data for each meeting.

Now the Issues begin.

Issue 1: I have a form for data entry. In the form it has two combo boxes (cmbMeeting and cmbName) and several text boxes that have the relevant data. The form has to be populated based on meeting the criteria of both combo boxes. The cmbMeeting is populated from a query (qryDistinctMeeting)to get only the distinct meeting dates. The cmbName is populated from a query (qryNamebyMeeting)that gets all the records that have the Meeting date (from the form cmbMeeting). What I need to do is populate the form from selecting a name in cmbName. I can do it by setting the text attribute of each text box separately based on the column of the cmbName. This works, but I am not sure how to accomplish Issue #2. Is there a simplier way to do this?

Issue 2: I want to change information in the text boxes and have this update the appropriate tables.

Issue 3: I want to do a NotInList for both combo boxes that will add a new record if new information is entered.
 
What I need to do is populate the form from selecting a name in cmbName. I can do it by setting the text attribute of each text box separately based on the column of the cmbName.
If you haven't applied this technique, then this article will be helpful...http://support.microsoft.com/kb/319482/en-us
This works, but I am not sure how to accomplish Issue #2. Is there a simplier way to do this?

Issue 2: I want to change information in the text boxes and have this update the appropriate tables.
You could have two buttons on the form, one for adding a new record if the information is new, and one for UPDATING the record if (any) information populated from the combo boxes will be changing. You can update query information and the changes will be reflected in the source table by default.
Issue 3: I want to do a NotInList for both combo boxes that will add a new record if new information is entered.
By default, combo boxes have this property (I believe it's true weather they are based on queries or tables), so this should be no problem. If it is, change the source to a table instead of a query, or do you need the query...if you do need the query as the source, is this really necessary??

Also, THIS....
The cmbMeeting is populated from a query (qryDistinctMeeting)to get only the distinct meeting dates. The cmbName is populated from a query (qryNamebyMeeting)that gets all the records that have the Meeting date
says you querying twice on combos. Might be easier with just one qry. I would assume the "date" data and "name" data from meetings are in the same table.

From all of this, it might just be easier to use the "hands-on" approach if you have a file to post...
 
Last edited:
Getting closer

Here is what I have so far. The issue now is that when I change the data in a text box, it doesn't change in the table. Also, it appears that on loading the form it changes data in the table.
 

Attachments

What I need to do is populate the form from selecting a name in cmbName. I can do it by setting the text attribute of each text box separately based on the column of the cmbName.
You were right to set the control sources for those txtboxes to the table fields, but I think you are trying to accomplish too many tasks with one form. Plus, if you have users for this, it might be a tad confusing if you can even do what you want. I would think that a normal setup for this would be to create 3 forms (or subforms)....one to display meetings, one for modifying meeting data, and one for adding new clients to your database. Spice it up by opening these with your "new meeting" and "add client" buttons on the form. There is certainly a wide variety of ideas with that sort of setup.
For one thing, you will be able to navigate better through the file for when it needs a change or an update....

Also, the form in your DB does not need a query. Your tasks can be accomplished with control references. You might not need a query at all....it just depends on how complex you are looking to get with this....
 

Attachments

I was leaning that way

I was planning on creating pop up forms to add new clients and meeting info. The meeting info is subject to change/correction after it is originally entered. I figured it would be simple for the user to select the Meeting date and then the client that they want to update....make the changes and move on...I am not sure if a button to update the changes would be beneficial....someone might make changes to several meetings and forget to click the button...any advice/input would be greatly appreciated.
 

Users who are viewing this thread

Back
Top Bottom