Search results

Crazy question, is there a way to force an after update selection on a combo box without actually making a selection? Reason I ask this is when my form opens up after the value is passed to the combo box, the only way I can get the other fields to display (currently not visible until a selection...

Thanks MajP, I ran into another issue now, I get the value passed however the function that happens on this combo box is when a selection is made (on the change event) would open a subform with the action to add more quantity into stock as well as displaying two other controls when a selection...

Greetings all, Been a while since I have needed some help, sadly that time has come again haha. So here is my issue this time. I have a form that I have created a link from one of the fields called Product, I have another form that has a combo box on it called cboProduct. What I would like to do...

Thank you both for the info, I guess I never really thought of doing it where it doesn't necessarily delete and move the record, but just flags it with a field called deleted or whatnot. The person I'm creating this for was something he wanted to do because on the forms it had a monetary value...

So I have run into yet another fun issue with my database. I have 3 different forms that I utilize the Audit Trail with, this part is working fine finally. I now am running into an issue where on my forms I want to move the records to a Deleted Table to have a better viewing of what was on the...

Greetings all again, I have a form with an unbound subform as I don't want to select just one record in my subform when I am searching. What I have is on the form is a search record box which allows the user to type in the record and go to that record. This works fine, what I am trying to do now...

Thanks Pat, I found I had some code in my OnLoad that was actually causing it ugh lol.

So basically I am running into an issue where I have a form to track expenses. When the form loads, instead of having New in my Expense ID field as being a new record, it loads up to the new Auto Number already generated. Issue I have is when the form loads, it creates the record in the table...

Wanted to do a quick reply back on this one. I have come to a solution that will work for what I am attempting. Basically I have a subform built off a query including my orders, other order details, and other inventory tables. When the person selects a part, it autofills the other textfields and...

I tried using this for my delete query, it seems to almost work but I am getting the enter parameter msg when trying to click on the remove button. The code I am using for the delete query is below, and yes the delete query is the one called QryRemoveOtherInv. The subforms record source is a...

Greetings all, I have a question maybe could get some assistance on. I have a subform that will display parts available based on specific vehicle information (Year/Make/Model) this all works fine. What I am trying to do is when lets say I add more than one part to the subform but then realize I...

I was able to get it to work on the LostFocus event of the Quantity Combo box. I used to code below to make it work, it currently suites the need I am having :) Private Sub Quantity_LostFocus() Forms![frmAdminOrders]!EstJobCost = Forms![frmAdminOrders]!txtEstCost...

Unfortunately that didn't do it :( I don't see why when the total field that sums everything up changes, I can't get the bound text field to update correctly. The first pic TotalCostSum is the amount that is stored in the unbound field and is the sum of all fieds on the form, the second pic is...

For this particular issue, basically I have a field on the mainform that takes quantity times a set price. 1. Part 1 Quantity * Cost (This is sent to its own unbound text box called txtEstModule) Then I have a total of 3 Subforms with their own calculations done, these have 2 different...

Other problem doing it that way, is I have other fields on the main form based off calculated fields and quantities. When I use the Me.Parent.Recalc method it clears out the subforms total to 0, and only keeps the other calculated fields cost. :banghead:

Would I do this on the afterupdate of the unbound field?

Name is confusing sorry, basically I have a query that takes a cost price and multiplies it by the quantity. I then pass that total to an unbound field that then updates a bound field. Yes I know not to store calculated fields in a table, but it seems harder to not store the "sale" of the part...

PBaldy, Thank you again for your help. I don't know why I can't remember that bit of code. You helped greatly!

Hey all, I am having an issue I have an append query that is to add new records to a table. The query is tied to a button that checks to see if a checkbox is checked and if so to run the append query. The problem is when I check the box and then click my Save button nothing is copied over, but...

Does the form need to be a continuous one in order for this to work as well. When I do so, if I click on the button to it goes to the end of the list and then gives error can't go to that record. If I display all records it shows more than the amount I want to see at once. So basically if I only...