Recent content by Kennelbloke

I believe that this maybe something to do with Column G. On the Colours sheet, this value is numeric (right alignment of cell) and on the array returned it looks to text even though the column is formatted as a number. If that is the case then how would I fix this? UPDATE!! In case anyone...

Hi Folks. Just trying to get a bit Excel happening, not my forte, but can't work out why I'm having this issue So 3 sheets. Entries/Breeds/Colours I'm using the Unqiue/Filter combination to get the base of the data I want. With the Finction below in F1, I get the following What I'm trying...

Thanks Software RT, that was it. It seems strange that code pause on the error and debug returned the correct value, which to me says that the object was there. Wierd... Oh well on to finishing this up. Thanks for the responses guys and have a great day.

I have used this process many times before but I'm can't get this to work main form: (button click event) ... strSexVal = 2 DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenForm "frmPetDetails2", acNormal, , , acFormAdd, , Me!PetID & "|" & strSexVal frmPetDetails2 form: Private Sub...

YES!!!! That was it Duane. Thank you so much. Removed the Link Master/Child fields for the subform. One headache out of the way :)

Ok I'm back. Reading through the much appreciated replies the following applies. Affectively the prefixes on the left are just the filter for the subform. Every time a prefix is clicked on, the subform is requeried (i.e. Me!sfrmBreedersCats.requery) I have removed the BreederID from the query...

Sorry guys, have to do other things for the next few days will check your responses later and get back to you thanks so far

The user doesn't enter or edit data on this form. The form opens with the BreedersID from their details form. All I want them to do is select a prefix on the side to see which cats belong to that prefix. They can double click on the cat to open that record if they want. It works for one...

I have a form that has a subform attached that has some weird behavioural problem basically when I click on a Prefix field and using onclick and a requery it should update the subform. This works in one instance but not for others. When I open the subform on it's own it shows the correct data...

Can you share the SQL behind the report?

Thanks Duane. You got me thinking that I was heading in the wrong direction

YES! got it to work. Not sure how elegant it is but it works for me. So... first off I created a public variable called TransID (integer) On the income field in the Balance form on any field I put this This takes me to correct form. On that form in the On Current Event I put the following...

Ahhh... it seems you refer to them as tabs (with the tab property) anyway. I will keep playing

It called a Navigation Control. Different from a tab control

Looks like the video didn't go through