Search results

Ok, that would make sense if the same code didnt work in the Main form, but it does. I basically copied the code and pasted it into the next forms OnCurrent event and modified some of the 'If' statements, so essentially it is the same code. KJ

vbaInet - I get a runtime error and then when I debug, this is what is highlighted, incidently it is the same code that is on my other form that works. If DLookup("[SecurityLevelID]", "tblLogins", "[UsersID] = " & Forms!frmLogin!cbousersel) = 1 Then Not sure why this is different...

I figured it would be helpful to see the code I am using. This works on my Main form in the OnCurrent Event: If DLookup("[SecurityLevelID]", "tblLogins", "[UsersID] = " & Forms!frmLogin!cbousersel) = 1 Then Me.cmdtablemaint.Enabled = True Me.cmdaddnewuser.Enabled = True...

I have a login page on my database where in order to gain access you need a user name and password. Each user name has a security level assigned to it which I would like to have dictate what parts of the database are available, I have the code working for my main form which opens after...

THis is resolved. I forgot to link the parent and child. Now it works as it should.

I have a form (frmCashSales) and I have a subform which is continuous (sfrmSalesDetails) on that form. What happens is when a product is selected and added to an order it goes from a drop down on the form into a line in the subform, users can enter as many products as they like, but when they...

It looks like what has happened is my record source was not set right. It works now, but the caveat to all of that is my customer notes entry needs to now be added to the form as a subform since I have it set to date stamp all of the notes as they are entered. Minor setback, but worth it in...

The form still comes up blank. Is there anything that I need to do with the form I want to open in order for it to recognize the CustomerID being passed by the dbl Click event?

Ok, I tried ammending the code as you stated, but the frmCustomers still opens but is blank. I am missing something here.

I have a Form named frmCustomerList which is a datasheet view form and what I am trying to do is when I would like to edit a particular customer, I would like to double click on the CustomerID field and have it pull up in the frmCustomers so it can be edited. I found some code that seems like it...

I have a question. Is it possible to code a combobox to be visible on one form based on a condition of a checkbox on a seperate form? What I have is a main form (frmMain) and a Customer form (frmCustomers), what I want to do is have a checkbox on the customers form drive whether or not the...

I will try that. One question though, I am unsure how to call the sum based on the Customer ID, I guess what I am asking is how do I write that criteria in?

I have an unbound textbox that I want to have populate the total amount in sales for one customer on the customers information page. I tried building a query and calling the result with a DLookup command and it worked for the total, but when I changed from one customer to the next it carried...

I cant seem to figure out why this error message pops up. I have used the POS database example by Bob Larson and modified it to fit my needs, but havent really changed much of the code except for some wording on message boxes and I keep getting the following error message when the form...

Thank you, you rock as usual, I completely overlooked that little tidbit...works like a charm now... I just found that little bit of code on the internet telling me how to do a multiselect, and tried to modify it to my needs. Only reason. I would try your suggestion too, I just am new to...

Awesome, I knew that the spaces are a bad idea in field names, but only found that out much later into the development so I decided to not change them. Forgot about the brackets. Now I am getting the following error: The record source 'Select Products.[Product Name], Products.Description...

I am trying to get a combobox populate off of a previous combobox selection. I am receiving the syntax error: Syntax Error (missing operator) in query expression 'Products.Product Name'. Here is the code I have on the after update event of the first combobox: Private Sub...

Well, I appreciate your time. I will possibly try to recreate the form and see if I can follow what happened. Right now the form is quite complicated and I couldnt begin to troubleshoot a record source issue. I will keep you updated if I find something... Thanks again, KJ

It filters to no records

I changed the code to the code you provided and still nothing... Recordset Type: Dynaset I am at a loss.