Search results

No joy on this either. Stock_Form1 is an subform pulling in one record dependent on the stock code entered in by the user. So, if the user enters code 12-345-678 the subform will check the datasource and provide the cost price. Is it because I am adding a field from the main form with a...

Hi Peter, Thanks for the reply, the error has persisted. Is it something in the set up i'm doing wrong? I have the field, drop it onto the form the results are needed on. I then enter the properties of the form and then enter the code you suggested. David

Hi, I'm trying to multiply two values, one from the main form, one from the subform into a total on the main form. I've set the expression in the control source as this.. [RH_TOTAL_CREDIT1]=([RH_QTY_CREDIT1]*[Forms]![Stock_Form1]![STK_BASEPRICE]) Is that completely wrong!!?

Hi, Sorry for the title - Not really sure of the name of the issue we're having :banghead:. I have two forms made up from tables from the server 1) Market Categories, 2) Market Countries. The object of the database is to categorise products from another table (Stock) based on tick boxes...

I knew it was something basic like that. I've gone back to two databases i've made before and now i've got a clear head it's all so clear that's what i've done before!!

Hi All, I've been making a database, and for the life of me I can't remember something that I used to consider slightly basic :banghead: I've got two forms, one header, one detail. When a user enters a record on the header it gives the ID (PK) field a No, when the detail is entered it...

Hi, I need some help with VB as I haven't got a clue on how to use it :) I have made a database which deals with customer returns, the difficulty is the final report stage, and unfortunately the requirements of the report have forced me to use crystal, rather than acess reports. I have...

Any news on this?

Hi All, I have a problem with the way my report is displaying info. I have it creating a sheet based on records in my main/subform combo form. The issue I have is as follows; I have a primary number, sourced off the main form. And a detail number, sourced off the subform e.g 1A,B,C,D etc...

Hi, This is probably a basic question, but it's confusing me!:confused: I'm creating a database for my company, the main form is working a treat, and is in the process of being tested. However for other parts they only want to see certain info on certain forms, pulled from the main form. Eg...

I'm working on the live version, users are working on v2, i'm on v2.1 I haven't split the database, within the company there are several databases - These have been consilated into a central one via switchboard. This is the only new one that has been added manually - The strange thing is that...

Hi All, I've reached the point now where i'm releasing my database to end users to use. Cosmetic changes were requested by the users, so i've attempted to do this - However, when the changes are made and attempted to be saved, the system goes through the normal process of confirming what to...

Tried this action, same result! :(

It may be that there are no records to show, try adding a test record?

Any offers? :)

Hi, I have a basic form/subform database, I have been assisted with this slightly by creation of a trigger on SQL. The trigger says that when the main form is deleted, deleted all applicable subform records. This is also true for data entry, when the form is populated, the subform needs to be...

Hi, I have a form/subform combination on my database. One record on the subform can relate to several records on the subform, i.e Record 1, has five incidents on it so records in the subform are 1.1, 1.2, 1.3 etc. I then need a print off of these in report format, I only need a single record...

Hi, I have created a link between my form and my subform, I need the main form to be record specific e.g., Record 1A - Faulty Item Record 1B - Damaged Item Record 1C - Missing Item These would be reflected in the main for as records 1,2 & 3. However what I would like to do it link record...

No need to upload the DB as the suggestions you've made have got it working perfectly!:D Thanks!

The control source for both is blank. Is it because of that?