Search results

Numeric field? cmbCDC is populated from a query. I assume that it is a lookup field then? Here is what I have....I have two tables tblIncident has the following fields: ID Log# 'there will be several of the same log# entries CDCNum 'there will be only one CDCNum per Log# but could in...

Still no cigar I tried changing the code to the different ones and I got a "Data type mismatch" error....the first code I wasn't sure of the quotes...here is how it looked. Me.RecordsetClone.FindFirst "[ID] = '" & Me.cmbCDC & "'" ^...

thanks so far Me.cmbCDC IS a text field....that is probably the root of the error...how do I treat it as such?

I have a database with 2 tables. One table is the specifics for a person. The other table is for tracking incidents with these people. I have a form (frmEdit)that has a combo box with the person's ID in it and you select the ID and the form should populate with the data on that person. The first...

Any Ideas I usually get a response quickly. I don't think this should be a tough issue.

I have a database with 2 tables. One table is the specifics for a person. The other table is for tracking incidents with these people. I have a form (frmEdit)that has a combo box with the person's ID in it and you select the ID and the form should populate with the data on that person. The first...

What a dork I found it. I had the List Rows property on the combo box to 1... Still, thanks for the help!

I have a form that has two combo boxes. When the drop down arrow of one box is clicked, the data displays correctly....several items visible at the same time. The other combo box only displays one item with a SMALL up and down scroll buttons to navigate to the item....I have looked at every...

I tried...not quite I tried, but it didn't work...I did try to create parent child links but I am limited to 3 links...I have many more. With the links, it displayed the first record but did not change when a new number was selected. I will be waiting patiently....Thanks Here is the new...

?? Here is the database....The subform is not based on a query. It is linked to the table. I need to edit the data in the form. I can't figure how to get the data into the subform... Hopefully I am explaining myself better

I have 2 tables (tblName and TblOffense) and a form with a subform (frmOffense and frmSubEdit) In the table (tblOffense) there are several entries for an offense and each offense will have an entry for each person involved. i.e.: Offense IDNumber charge decision 0001...

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...

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.

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...

Thanks I was able to figure it out with a query based on the form, I am sure I will be back with the next issue that pops up!

Ok here are the issues. I have a table and a form. The table has several fields. One field is a Log number and another is a name. The table is currently set up to have multiple entries with the same Log number (one for each person involved in the Log number) The form has 2 combo boxes one for...