Search results for query: *

I've been trying to make a field (Cities) in a joined table update to reflect when a new city entry is made in a form where the city is not already included in the cities tbl. Each city has a unique autonumber, which serves as the primary key. If I were to use the city name itself as a primary...

Sorry, I have the code as below, not as it is above (Forgot the "Me."): If Nz(Me.Combo8, 0) = 0 Then Combo8 = DLookup("[NewENum]", "qryWhereNow")

Hi I'm trying to cause a field on a subform to update when data is entered in a field on the main form, but because one is on a subform and the other is on the main form, Willir supplied me with this code, which is working in all respects except that I cannot run it from the main form, only...

Epsilon101 Regarding the mouse wheel, if you set the Allow Additions and Allow Deletions to No (Making sure to leave Allow Edits set to Yes), the mouse wheel will stop navigating to new records. This is assuming you aren't going to be doing Additions or Deletions in the subform, of course...

Its working! Many thanks Willir, I owe you one ;-) I do have another question for you though. If you can picture this, I'm trying to get the information on subforms, to update one field is entered on the main form. If I put a button on the sub form and press it, then the information updates...

Willir I have been having trouble getting your code to work. The code itself, and what you're getting at makes sense to me, but for whatever reason I keep getting errors. I'm going to focus on the Numericfield example you gave, since all of the fields I'm referencing only require a number...

Using the DLookUp function, I've had success looking up the default value for certain fields on my form, but I'm run into another problem. The form tracks transfers of assets, and queries of the tables determine where the asset was most recently, and in doing so determine the default value of...

Perfect, that was exactly what I was looking for PHV. Many thanks! :)

The pertinent table records transfers of assets from employee to employee, and assets are often transfered more than once. How do I set the default setting of a forms control so that when a serial number is entered, the last Location and Employee Number (that the asset was formerly transfered...