Search results

Hi vbaInet, the Where argument didn't do anything different, adding the ID to the SubForm fmrQry_sf_Sell did. After a nap on the couch I noticed that The SubForm didn't have the ID field on it and it assumed automatically that it had to take the ID from the tblDocket. Since my form frm_sf_Buy...

That did the trick, =DMax("ID","Qry_sf_Buy") However, if I make a new textbox and use =DMax("ID","Qry_sf_Sell") The record show 9 and the text box shows number 172.. When I look at the ID's of tblDocketSell #10 is the highest number?? Strange...

Just asked a new question as new treat as this problem was more then resolved by you it helped me to make the app far more efficient.. Well done..

Hi All, Trying to take the last ID on a SubForm and make it appear in a unbound textbox SubFormID.. This without typing it there.. :D e.g; on screenshot, the last ID on the SubForm is 134 and I would like to get that in the textbox. Any help appreciated..

Thanks vbaInet, this link made it possible to seriously improve my skills and application..

Thanks for the hint, this will give me some to check, will get back with the result so other might enjoy the solution too..:)

Works like a charm vbaInet, this is the code; CurrentDb.Execute "UPDATE TblDocketBuy SET [E_Weight] = " & Me.TxtWeight & ", [B_Price] = " & Me.TxtPrice & " WHERE ID = " & Me.ID & ";" One small problem however, my main form now says record set is not up-datable for some reason. So I removed both...

Going on site now, but thank you very much for the hint.. Will look at it this afternoon and tonight.. Probably need some time to check it out but keep you posted on the result.. Great job..:)

That wasn't the full process.. ;) Thought about that but don't know where to begin so I better start reading.. unless someone has a bright idea how to select a record of the subform.. and could put me in the right direction.. Well you did anyway..

Great, Be well and prosper..:)

The application operates a Weighbridge, A driver registers in the office, a docket is created using the form frmTouchscreen, it registers customer name, vehicle license, haulier, sales rep and weighbridge operator. Then the operator switches to frmMultiTouchscreen where the Unloaded materials...

If you post the app I can have a look later on..

Sorry, thought the application would show.. Here is the screen shot, I have created record vbaInet, but now need to enter the Empt weight. Since I did not know that when I created the record. Eventually the scale will be connected to this.. But manual input would get me a great end..

I would put the buttons on the original form saves looking at another popup a further explanation would be useful... (in my case) . As far as Macros vs Code, and I am certainly no expert so don't count to much on my opinion, events are far more flexible and traceable. But again that is only my 2...

There is no code m8, open Attendance form in design view, click on the field EmpName, right click for properties and in the second option Control Source choose EmpName, this binds the formfield EmpName to the tablefield EmpName. That's all there is to it.. Cheers..

Now my Japanese is not that good, the only word I know is konicua or something like that but I would say there is a link missing in the Relations or there is no proper Master Child connection. Hope this puts you in the right direction..

Hi Just bind the txtbox to the correct table field..

Hello All, For over a week I have been reading this board and google etc, still have not been able to come up with a solution to my problem. I sincerely hope someone out here could give me a clue. In my subform I have a list of materials and weights, price etc. This is gathered from a form to a...

What else would we do with our spare time??;)

Ruud, I have a similare situation where I work with visible and invisible, it will only work in single view form and the code needs to be added both in form on current and the command button event.. Sample; Private Sub Form_Current() If Me.Sale = True Then...