Search results

ok, i will try to redo the form and see if it works. If not, I guess I will just use the empty code. Thank you.

How do i type out the code? So there is no way to solve the root, only a workaround?

Nope, its still the same.

Its in fom_TaxInv. The correct one is Client Name combobox. The address and the rest is its populated textbox. The one with the error is cmb_InvNo. The populated textbox is Text55.

Sure just let me remove condential info

just select all the text in the combobox and backspace

Yeah, there's a filter code for the subform. But its in the after update event. Which I also did before, and it works alright. Just suddenly the value in the textbox doesnt clear itself. This is a new textbox and combobox that i added in the form, just to clarify. The old one works perfectly.

its the same thing? because when i google, they only show put in on change event.

Hi I tried to populate textbox from combobox and it works. When deleting text in the combobox, the populated textbox will return to null.. Now when i tried to add a new combobox and textbox, the textbox does filter based on the combobox. But the textbox still show the last populated text...

Due to the confidentiality of the info, there is a lot data that needs to be deleted. The time taken for the query to load will be shorten considerably. It's ok then, thank you for your help.

Yes, I am using allen's concatrelated function. There could be more than 1 invoice per month. There are only 2 tables in the file. I make sure that the data is always for 1 year only, so its a small file. One contains the 'Name' and their relevant particulars, such as ID. The other is a list of...

Hi I am using allen browne's concatenate function. But it takes some time to load. Is there any way to speed up the process? I am using a crosstab query that looks something like this where xx is the invoice number. Name Project 2016 2017 2018 ABC 1 xx xx...

Hi I am starting to learn access to apply to my work so that things can be faster. I have been using excel but there is too many repetitive work that can be done more efficiently with access. Everything I learn in access has been self learn. So I only know the basics and only know to copy and...