Recent content by bd200

Cronk & JD you both are legends... Cronk you were right, 'txtQuantity_Called_Off' was referencing the control name on the subform & not the source.. oops ! JD the code works a charm. You da man Much much appreciation to both you guys. :D:D:D

Hi JD, Thanks for the almost instant response !! Ahh ive spent all day failing to write this tiny snippet of code :banghead::banghead: Unfortunately i tried your code and recieved the following error: Run-time error 3265: Item not found in this collection Debugging highlighted...

Hi Guys, Im v new to VBA and been having trouble getting the following code to loop through the records in my subform: Private Sub cmdComplete_Call_Click() Dim rs As dao.Recordset Set rs = Me.fsub_Call_Off_Quantities.Form.RecordsetClone rs.MoveFirst Do Until rs.EOF...

Hi Spikepl thanks for quick the reply... "If all else fails, create a new textbox, in the property Control Source click the ellipses and choose th expression builder. There navigate to the desired control and click paste. Now you have an expression you can copy" - I used this to avoid having...

Hi guys, As some background info I work in a small business with my brother and father and get a lot of our orders via email. We had a database on access 2010 made a little while back by an "access developer" that i have been adding too and tweaking ever since with my very limited knowledge...