Figured this out. It's working now. I'm not sure how, but at the table I had lost my Autonumbering on the ID field??? I must have gone and looked at the table several times without catching it. I've set it back (on my og database) and changed the placement of the vbCode for the Code control...
I've copied the necessary forms, tables and queries into a blank database and removed sensitive data to show you what's happening. If you open the Purchase Order Details form and click New PO, you can tab through the fields to see how it works. When you tab into the subform and put a line Item...
I did actually....
"I have found that by adding this new "Code" control into the subform I now cannot tab or arrow out of the current record unless I press Escape."
Just want to know why I can't tab or move out of a line (record) after adding in one simple field on the table and one control on...
The hidden field is on the subform because this is where the line items come from for the purchase order. We assign project or "job" numbers to these line items to tag the material for a project so having it on the main form would be ineffective. Sometimes we will order material from a vendor...
I have a database that I've developed for Purchase Orders and project tracking that has been working great for the last year and a half. It has been asked of me to add in a hidden field in the line items for the purchase orders whereby a "code" is placed based on the input of the Job Number...
Thanks for the reply. I have combo boxes at the top of the main form that filter the subform. This is where I use the "Like" statement. For example:
Private Sub Combo224_AfterUpdate()
Dim StrFilter As String
Me.Refresh
StrFilter = "SKU like '*" & Me.Combo224 & "*'"
Forms![Copy of...
Database is full of sensitive info, such as employee information and projects. Can you specify what information might be helpful in assisting and I can send whatever info is necessary.
I've made a purchase order system and am having trouble with a subform. My main form (Single Form) is unbound and has comboboxes set up to filter the subform. The subform displays as a datasheet. This works great except for one problem. My PODetail table has 17,000 records in it and the...
Code works great, but the text disappears as you type. Might be a little confusing for a novice keyboarder. How can i keep the text from doing this? I'll try both scenarios and see which works best for this application. Appreciate the help!!