Recent content by zeegoff

I know its pretty simple, I've never used access before about a week ago, no really sure of typical layouts etc. The easiest way to get this working is probably the best? The only reserve I have is we dont want to have to populate the second table manually, ideally we'd like it to add new...

Sorry for the delay, I'm over in the UK its just morning over here. I was playing round with an existing drop down it is the client field that we want to get working, its not a problem having another table if thats whats needed but would that mean populating a list manually rather than on the fly?

I think i've done this right? Ideally we'd like to be able to enter new clients into the dropdown and have them auto complete if we have to input them again. Any advice or comments good or bad are more than welcome. Cheers!

Really appreciate the help, I know its probably not the easiest advice you've given! would it be easier for me to host a copy of the database for you to download? If its not a simple fix its no problem its more of a time saver than a necesity.

There's only one form, I'm getting the drop down fields from a "clients" column in my table, and I'm trying to add on the fly to the dropdown? have no programming experience unfortunately!

Thanks :) I've gotten a little bit further, found this code and edited it to apply to my combo box and to pull up the right form, I get the "would you like to add" to add message, click yes but then get the same not in list error?? Private Sub cboDepartments_NotInList(NewData As String...

Hi guys I've been trawling the net for hours and cant find anything so I thought I'd try here to see if anyone has a solution for me. I've just picked up access this week and have designed a form that helps us produce job sheets in my place of work, the form works as it should I'm just trying...