Recent content by j2curtis64

Hello, I am creating a search form where an end user can enter a field in a text box, then hit a command button and values are returned. The problem is I have two fields that are text (cardholder and approving official) and the values are being returned as numeric in the form. I am expecting...

I've created a database that I am using to track issues. I have two tables. Contact table that consist of the following columns: ID, full Name, Position, Site, HierLevelSix, and CC Issues table consists of the following columns: Monthly, CH_ID, AO_ID, DateIssueOpened, LastUpdateDate...

OK...here it is. The Issue Details is the form I've been working on. There are two tables (Issues and Contacts). The Issues table is empty. When data is entered it will be stored in Issues table. The contact table has names, numbers, etc....

This is still not working. The .txt box is not updating the table. I updated the code to the following. Combo box - ApprovingOfficial (control source) After Update Private Sub ApprovingOfficial_AfterUpdate() Me.AO_Credit_card = Me.ApprovingOfficial.Column(2) End Sub Text box -...

Hello, I am going to try and provide more detail. I want to do the following. I have a combo box with a field named "Approving Official". This will contain names. In the same form i have a number field (AO_CC-text box) that i want to update automatically based on the "Approving Official"...

Now I am noticing when i input data in my form the primary key field in my underlying table is not populating. Any one know why? The other fields are updating.

Thank you very much! Mark

Hello, I want to be able to update value in text box based on the value in a combo box. This would be in a Access form. For example, I have the following values in a table. Name Number Johnson 1234 Curtis 5678 Jones 2468 In my form, one...