Search results for query: *

Hi MajP. I'm not sure if I still have a question or not. Your suggestion worked in that it changes the dates by the room number and I am able to edit them, but the dates are defaulting to January 1900. I'm trying to find out where it is getting the 1/14/1900 info to see if I am pulling...

Hi MajP It is a hospital Rehab and the combo box shows the room numbers on the floor. When the room number is selected, the patient's information is displayed. I have 2 text boxes that need edited. Admission Date and Discharge date. As the nurse pulls room 612, enters the date 5/5/2010 as...

Hello, I have a combo box that needs to fill some text boxes when selected. However, the user will also need to edit the text boxes. Everywhere I've looked, I can only find info on UNbound text boxes. This is what I have for the onChange event for my combo. Private Sub Cbo_UnitNo_Change()...

I identified each field with the Control Source. With the unbound fields, there is no control source so I don't know how to identify that field.

In my form, I have a button that creates a vcd card so it can then be saved in Outlook. I am able to capture bound fields in the VCD, but I can't capture unbound fields. Do you know if it is possible to capture unbound fields or not? If it is possible, can you tell me how? here is an example...

It works! I removed the Group By and I changed the join to display All GeoDataSet. I had it wrong and had it to display all Attributes. Thank you very much for your help and patience.

Ok, I see the group by. The GeoDataSet.GeoDataSetID is the primary key and the Attribute.GeoDataSetID is the foreign key. The relationship is one to many...GeodataSetID is one and Attribute.GeoDataSetID is many

Here is the SQL SELECT GeoDataSet.GeoDataSetID, GeoDataSet.GeoDataSetName, GeoDataSet.SourceID, GeoDataSet.GeoDataSetDescTitle, GeoDataSet.Purpose, GeoDataSet.Abstract, GeoDataSet.Notes, GeoDataSet.ProjectionID, GeoDataSet.DHS_SectorID, GeoDataSet.DHS_SubSectorID, GeoDataSet.DHS_SegmentID...

Sorry for my confusion. I have a form for a user to fill out..First Name, Last Name, Address, etc as well as drop down boxes to select Data (segment, Sector, Scale). All information for this is on one table called GeoData. The form was working fine until I tried to add another text box for...

I guess my understanding is the row source is for a combo box or list box. I am trying to bind a text box so the user can add data into that box. The only way I know how to add the field I need into the list box is to go into the record source and add the table I need. Thanks!

Newbie here! I have been working on an existing form for about a week. This morning, I added a text box. I needed to add the information into the list box, so I went into the query and added the table and information. Under properties, I was then able to add the data in the Control Source...