Search results

Appears you need to start by reading the following. http://symplebyte.com/microsoft_office/access/how_to_normalize_data_access.html Dale

Code, queries, forms, reports, relationships........ all make the data base grow. Data is the least of these. Compact and repair helps. Dale

Dim db As DAO.Database Dim rsqry As DAO.Recordset Dim rstbl AS DAO.RecordSet Dim strSQL As String Dim CheckOut As String Set db = CurrentDb Set rsqry = db.OpenRecordset("qryTally") Set rstbl = db.OpenRecordset("tblControlTable") Start by changing the bold and adding...

http://www.access-programmers.co.uk/forums/forumdisplay.php?f=55 Dale

please be a little more specific as to what you are wanting to do. From where, what data and from where. Text boxes, combo boxes? Give us all the details you can. Dale

I don't use Macros much. I do know they don't like to search/filter form table to table. Try putting the following in the underlying query. Forms!FormName!ControlName in the field you want to filter. Dale

Your logic is off I think. The way you are setup on tblAccessories and tblAccJ means the tblAccJ will have many entries and tblAccessories will have 1. Are there many AccJIDs for 1 Accessory? If so then you are correct. Dale

Sorry, I don't know where I got the idea you had only 2 tables. Your relationships look backwards to me. Some should be reversed. The 1 is on the wrong table. tblProjects tblAccessories tblStructure tblPurge tblVess tblPilFlameDet tblPilIgnittion tblPilot Tbltips Look backwards to me Dale Note...

What I am saying is look at your RowSource for the combo boxes when you return to a prior record. What is in them? Are you resetting the Rowsources to reflect the rerturn to another record. You may (should) requery when starting over with the first combo box. Are you getting what I am trying to...

Something in the form is making a new record when it is opened. Can you upload the database? Dale

Post a picture of your table relationships. I am wondering why a many to many relationship with just 2 tables. I am thinking a 1 to many. Dale

It sound like you need to read the following. http://symplebyte.com/microsoft_office/access/how_to_normalize_data_access.html Dale

Does the form add a new ID number to the table or just open the form to add a new record? If the form is adding a new ID number then something in the form is dirtying (creating) data. If it is opening to add a new record the check the data tab for Data Entry Yes and change it to NO. Dale

If I underastand your problem correctly. Your answer is in your question. And The combos boxes are filtered until a selection is made in cboLocation. Dale

It the query an updateable query? If you would tell us what you have and what you want and we can possible help you find an answer. Dale

Change to After Update Event. Dale

I guess I don't see you problem then. Dale

Put the fields you want in a query. Use the query to make the form. Dale

What are you trying to do here? DAle

If I understand you correctly, Your concern is that the labels and fields stay connected. I do not know of any way to stop this. Align and size will work on either alone. Dale