Search results

Great that resricted it to that record. Now the other problem is that that record has multiple entries in the other referenced table, of sales, so I get the list of those entries. IE 5 sales with that reference. Not sure that this could be easily understood. Thanks for your help!

Hi How do I just print the active record to a report? It is not a continous form. I have but a report button on a form but when I run it, it shows all records, one on each page. I just want the active one only. I may also be adding a macro inbetween the form and the report to gather some...

I think actually the Other Sales form maybe based on a query, I'll check it, and if not change it. All the Sales are in the same table, but are being displayed by 2 forms, one relates to Photos, hence has the PhotoTitle Field the other relates just to Customer, so doesnt have the field. I'll...

Hi I have 1 table (Sales) being displayed by 2 Forms (Customer Sales & Customer Sales Other). 1 form (customer sales) is embedded in as a subform in a form called Photos, and the other is embedded as a subform in a form called Customers. From the Customers Form I create a report using a query...

ok, I'll try. i have a continuous form containing information like, PhotoTitle, Location, LimitedEdition and a field called Category. This Category field will be a combo box containing values like, Landscape, Architecture, Wildlife etc... I would like to place a button on the form to apply a...

How do I create a Form Filter based on list option? Can I create a macro to apply a form filter using a value from a selection list. IE, instead of applying a filter to a form were the Category field = One, can the filter start to run and return a list One, Two, Three, so I can then select Two...

ah, ok thanks. What would happen if I apply this code to a single version of the form, but then look at the continous version. Would it do strange things? I'm sure I can use this code somewhere so all is not lost. Thanks for your help. *** I guess it wouldnt effect the continous form as it...

that seems to apply to all the fields again, and produces a debug error on a new entry :-( Just to clarify, I trying to hide the entry in 1 field in 1 record of the continous form. The code above applys the the field across all records in the continous form

ok, sorry. I have a combo dropdown called LimitedEditionTotal which stores a values, 10, 20 etc... and a checkbox called Check20 (default name) that I want to use to control the visibility of the LimitedEditionTotal field. I have set the default visibility to false as WAZZ above suggested. I...

hmm, ok, so I cant do it then? The code you gave me refers to textboxes? It tried it with fieldnames and put the checkbox name, ie Check20 inplace of checkbox, but it throws a wobbly!

ah, thanks. Yes, it sort of works, but this is a continous form and it seem to show them all. I think I also it need to be in some sort of checkbox equals true option instead of after update? Any ideas?

thanks. However, not being familar with this type of coding in Access, do I just paste that into the properties dialogue area for update event, or put it in expression builder etc.... should 'me' be the text me, or a form name etc...

How do I hide a field by default then display it based on a checkbox being clicked? Thanks!

ok, great. So where of how should I create that query? ... ** Update, Yes!! I think that works! Or atleast in my test db, I'll now try it in the live one! I seem to have a funny dataform as well, but I'll try it in the live db and let you know. Hopefully have will work for customer...

ok. maybe I could do it a different way, and this could be my lack of access programming here but... I should be able to open a photo record which contains its title, and see a list of sales in a subform. I can, great! However, if I open a customer form with an embedded subform of customer...

Yes, they are linked using Filename

it doesnt automatically put the value of Form.Photos.PhotoTitle into SubForm.Sales.PhotoTitle. Even if I point the subform field to pull the value from the photos fields, it doesnt remember if for the customer purchase table use. I would have thought, if I have a subform within a form and they...

well thats what I thought, but it doesnt work. Please see this thread/question. http://www.access-programmers.co.uk/forums/showthread.php?t=143786

In case my other question cant be resolved, I'd like to do a work around, but dont know how to do that either. So, I have a form (Photos) with a field (PhotoTitle) and in the form is a subform containing a continuous form a (Sales). This form contains invoiceno, location, customer etc... but...

These are my table definitions Photo table. (data type of text unless stated) ID (Autonumber) Photo (OLE Object) Filename (primary Key) Phototitle LimitedEditionTotal EditionCount LimitedEdition Sales Table (in form embedded as a subform in Photos) Filename Phototitle EditionCount...