Search results

Unfortunatelly I can not get it to work. Tried different things but without look. It would need to be the same as if you would open the frmCustomerTab with the record selected in the sfmCustomerSearchMini sfmCustomerSearchMini is based on a query, qryCustomerSearch where I have a control...

Ok thanks guys for the posts! Cheers

Hi, thanks for your input. I believe it had something to do with the mouse rather then something with my code. Now it seams to work again. So I keep you posted if there is it again. Cheers

Ok I will try that thanks!

Hi, thanks for your reply! The button in on frmCustomerSearch Header. on that form I have a subform sfmAllCustomers. and when I select a Customer in that subform I like to open another form with that particular CustomerID I can open another form with that kind of code when I open a form...

Stuck again, sorry for posting that many questions but need to get some things done and getting stuck. What I am trying to do is open a form from a subform selection in another form. Problem is that the form I like to open has two subforms and a textbox in the header. Attached the pic of the...

Hi again, When I select a record in the datasheet view the form selects sometimes more then one record. Does anyone know what cause this issue? Cheers

Hi, ok I thought so that this might be the case. Thanks

Sorry Arnelgp did not get notification for your question. yes I did see it in design view.

Hi guys, just wondering how you can save threads you find interessting or particular posts in the forum? Cheers

Hi Doc, Thanks for that info! But what I did is deleted the subform and pulled it back in to the form and it worked again. Well easy enough pff.. But good Info and will keep that in mind if those kind of things would happen again. Cheers

Hi guys, for some reason I can not see my subform anymore in the mainform. Property is set to visible = true on the property Sheet. I got two subforms on my form and updated the second subform on Load Event to hide some columns in that subform. However now I must of done something to hide...

ah ok.. So when do you use what? I mean I can always edit the form can't I ?

But the Me.requery I can leave out right?

hmm I am not sure why it did Now I did change it to if isNull (me!CustomerID)...

CustomerID is correct. It opens ok without me.requery and for double click event I have following If IsNull(Me!CustID) Then MsgBox "Bitte wählen Sie zunächst einen Datensatz aus." Exit Sub End If DoCmd.OpenForm "frmCustomers"...

So you don't need requery? And is it also the same in an endless subform? Cheers

Hi guys, can't find the post and was wondering if someone can tell me if that code is correct? I have a main form in the header I have a button. in the detail secton I have a subform. This is the code I am useing. If IsNull(Me!sfmAllCustomers!CustID) Then MsgBox "Bitte wählen Sie...

Hi thanks Pat, I will look into it and also post without relevant tables. Just in the middle of something but I will get back to you! Cheers for your input and help"

ok On the FK Fields you mean? PrimaryKey remains as No right?