Recent content by HowardHelp

OK the other way would of been simpler but here’s some of the important pics

Is it possible for me to email you the cut down version of the database, as the tables are how they were designed, I don't really want to post the database on the site its under 1mb

It looks like i will have to stick to the combo box, I've tried or sorts of things none worked. The combo works because of the row source and the code SELECT [snCat1].[AUID], [snCat1].[fldMusicType] FROM [snCat1] ORDER BY [AUID]; the text box is different obviously.

Here is the query I just done the tables are not linked but the fields are below, look-up table is on the left

Are that sound's better, what do i need to include the the AUID and the filed from the small table and the field from the main tabel, and then link the field to the forms unbound box I just joined the field in the control source and its cumming up #Name? i don't think the query is right

OK thanks I’ll have a go see how I get on, ideally I just wanted a normal field and not a combo box in the subfield, but I’ve hidden the drop down menu with a blank box from the background and disarmed any editing.

Many thanks again the only problem I have just come up against is that the text is showing (as I wanted, the combo is situated in a sub form) but searching these fields still can only be done by the numeric code and not text, to me it's a strange why the main table did not just use text to start...

Hi sorry for the delay in getting back but I was having a go at a Converter Query which works well but was quite involved so I only done a few conversions of numbers to text. I shelved that temporary and continued down the combo route you suggested and was done in just a few minutes, I linked...

Many thanks for your help the form (field in question) is linked to the main table and not a combobox in the forms Control Source. The main table I refer to and don’t want modified has a combobox which links to a smaller table which what is causing my problem as it has the text and numbers in, I...

Ill treatment is a bit strong, just snide remarks about my lack of knowledge of access, all I wanted was some help, why post unnecessary remarks that has no bearing on the subject.

Hi can the table be linked to the form field, thanks for the sugestion

I must start by saying yes I’m a newbie not experienced unlike die hard access experts. I joined this forum because it sounded like newbies were welcome, but a minority of experts seem to revel in comments like practice makes perfect etc. and I should know what I'm doing so to them please go and...

Very Helpful

Yes the link sounds very much like the problem

Hi i tried setting the 0 to null on the main table, do you mean use the combo on the form, if so the problem with that is the main table is from another database, the values you see is read only in the form so i want it to reflect the table, thanks through