Recent content by ZX188

That wont work I need the data that is in the field befor the Update to change the checkbox back

Private Sub CoreID_AfterUpdate() Dim StrNoCheck As String Dim db As DAO.Database Set db = CurrentDb If [ServiceType] = &quot;Core&quot; And [CustomerIn] <> &quot;&quot; Then StrNoCheck = &quot;UPDATE Worksheet SET CoreOwed = 0 WHERE RefrenceNumber = &quot; & Me.[CoreID].Column(0) & &quot;;&quot...

I have written the code to update a check box in a db based on the input of a certain field on a form. This works ok the problem I have is if the field is changed back the check box does not change based on the data that was in the field before the change. It seams that the data is changed...

How would I make a field on a form required without setting the required proprities at the table level

I keep getting syntax error in FROM clause This is what I have done Private Sub PoNumber_AfterUpdate() Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String strSQL = &quot;Select Closed From PoNumber&quot; & &quot;WHERE PriKey=&quot; & Me.[PoNumber.PoID] & &quot;;&quot; Set db =...

Thanks for the help Sticking it gives me a good start Kevin

I have a combo box that needs to update a true/false check box in a different table based on the user selection of the combo box. When the user selects something I need to up date the check box in the record that corresponds with the selection How would I go about this? Thanks Kevin

I have a form that changes data in fields when a combo box data changes the combo box is using the primary key as its data source Question: How do I stop certain fields from getting updated when I change the data in the combo box

How would I go about updating a field in a record other than the record that I am displaying on my form

I need to have a field in a report that prints out its data with a &quot; * &quot; on either side Something like this in the fields record source =&quot;*&quot; & [Field in select query] & &quot;*&quot; but this doesn't work any suggestions ? I cant use text labels on either side because I...

First I would like to thank every one for all the help this has been one of the best Access forums I have found you have saved me days of research and taught me a lot not to mention the fact that I would have less hare. any how here is my next dilemma I have a orders form with a subform linked...

I Figured out what I was doing wrong the first combo box was bound to the wrong field Thanks for all the help

I also tryed it this way SELECT worksheet.[PO#], worksheet.OurPartNumber, worksheet.Description, worksheet.CustomerID FROM worksheet WHERE (((worksheet.CustomerID)=[Forms]![Orders]![BillTo]));

I get no choices in my other combobox You got it all correct except that the BillTo is also a combobox

Didn't seem to do anything do I leave my rowsource in the combobox the same?